Raj Ali

How to use a SQL Trigger. Pls give me the complete text query.

create trigger trigger_name on table table_namefor{[update][,][delete][,][insert]}[WITH ENCRYPTION]as sql_statementwhere trigger_name: names The triggertable:names of tables on which tge trigger has to be executedWith Encryption: Prevents other users from viewing the text of the trigger[update][,][delete][,][insert]: Keywords that specify the statements that will invoke the triggerSql_statement:Transact_SQL statements to be executed when the trigger is invokedIf You need Any other other help in triggers you can mail me

hi Every oneI have a table name Employee in which i want to make a column name moblie No.now i want to make a user defined data type in sql through query for column moblie No.now how can i make a user defined data type that it begins with 0......... can any one Help me??????????????

Nevermind, I figured it out.

If ur view is based on a single table than it is possible to update o insert into it.Likeinsert into<view_name>values(<column1value>,<column2value>........)update <view_name> set column_name=required condition where column_name=conditionand if view is based on the data which comes from multiple tables than it is not possible to update or insert into it.

Exactly what I wanted, cheers!

if u want to chose top 8 rows which are recently entered then u useselect top8<column_name>from <table_name>or if u want randomly rows from table then u useselect*from <table_name>

In SQL server u can try this querySelect Distinct Top 2 salary from EmpSalary Order by salary Desc

You use the querySelect top 5 salary from <table name>

I make a view which gets data from multiple tables through query in SQLNow i want to modify or update values in that view through queryAny one can tell me that how i add or change values in that view which contains data from multiple tables

my question is about sqlhow i create a pointer in sql by writing query?????Any one knows than tell me Thanx

Sir, How to make a user defined data types by query in sql Thanx Raj Ali