Answer Posted / 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 |
Post New Answer View All Answers
What are the advantages of stored procedure in sql server?
Using the customer, and order table in northwind database, please write a query to produce xml?
why would you use sql agent? : Sql server database administration
What is a unique key constraint?
What is scan table/view and seek table/view when its occurs? : sql server database administration
How do we synchronize On-Premise SQL server with SQL Azure?
Can we use trigger new in before insert?
Do you know what are the restrictions that views have to follow?
between cast and convert which function would you prefer and why?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What are the basic features of a trigger in ms sql server?
Where are stored procedures in sql server?
how would you store your query in an SSRS report or a Database server?
How to convert numeric expression data types using the cast() function?
How can you check the version of sql server?