Which virtual table does a trigger use?

Answers were Sorted based on User's Feedback



Which virtual table does a trigger use?..

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

Which virtual table does a trigger use?..

Answer / kapil

There are two virtual table
inserted and deleted

Is This Answer Correct ?    5 Yes 1 No

Which virtual table does a trigger use?..

Answer / sureshnaspuri

inserted and deleted

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More SQL Server Interview Questions

whats the maximum size of view state??

0 Answers  


How to list all field names in the result set using mssql_field_name()?

0 Answers  


How to write a query with an inner join in ms sql server?

0 Answers  


What is merge?

0 Answers  


What is filter index?

0 Answers  






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.

4 Answers  


how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,


How to provide Security for package?

1 Answers   Convergys,


Explain transaction server implicit?

0 Answers  


What are exact numeric data types in ms sql server?

0 Answers  


List few advantages of stored procedure.

0 Answers  


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

3 Answers   NIIT,


Categories