Which virtual table does a trigger use?
Answers were Sorted based on User's Feedback
Answer / bharathi
Answer is deleted and inserted
INSERT Trigger populates inserted table
DELETE Trigger populates deleted table
UPDATE Trigger poulates both inserted and deleted tables
Is This Answer Correct ? | 11 Yes | 0 No |
whats the maximum size of view state??
How to list all field names in the result set using mssql_field_name()?
How to write a query with an inner join in ms sql server?
What is merge?
What is filter index?
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.
how to find number of columns in a table in sql server 2000 and 2005 also
How to provide Security for package?
Explain transaction server implicit?
What are exact numeric data types in ms sql server?
List few advantages of stored procedure.
i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee