Which virtual table does a trigger use?

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


Please Help Members By Posting Answers For Below Questions

What is the difference between migration and upgradation in sql server?

610


How to connect php with different port numbers?

555


Explain candidate key, alternate key, and composite key?

592


SQL Server Architecture ?

1936


Ms sql server index?

546






What is the difference between SQL notification and SQL invalidation?

592


what is difference between view and Dip.

2003


How to create a view with data from multiple tables?

561


How do I create a partition table in sql server?

499


Is it ok to shrink transaction log?

520


Write the queries for commands like Create Table, Delete table, Drop Table etc.

615


How to query multiple tables jointly?

562


what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

501


Can group functions be mixed with non-group selection fields in ms sql server?

545


How to find the version of sql server? : sql server database administration

631