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

What is a trigger?

4 Answers  


How and why use sql server?

0 Answers  


why would you use sql agent? : Sql server database administration

0 Answers  


What are the different acid properties?

0 Answers  


Do you know what is xpath?

0 Answers  






How do I view views in sql server?

0 Answers  


Explain the different types of joins?

0 Answers  


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  


How to link tables in sql server?

0 Answers  


could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  


What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,


Data table as parameter in sql server?

0 Answers  


Categories