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 |
What is a trigger?
How and why use sql server?
why would you use sql agent? : Sql server database administration
What are the different acid properties?
Do you know what is xpath?
How do I view views in sql server?
Explain the different types of joins?
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?
How to link tables in sql server?
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
What are the different methods available under sqlcommand class to access the data?
Data table as parameter in sql server?