Which virtual table does a trigger use?

Answer Posted / sanjay

after trigger - insert - inserted logical table
delete - deleted logical table
update - insert/delete logical table

instead trigger - insert - inserted logical table
delete - deleted logical table
update - insert/delete logical table

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any body tell me how to know the password of current user in sql server

1572


How to use values from other tables in update statements in ms sql server?

551


Where do we use trace frag?

562


What is the difference between createstatement and preparedstatement?

485


How to delete all rows with truncate table statement in ms sql server?

480






Can one drop a column from a table?

544


What is 1nf normalization form?

585


What command do we use to rename a database?

607


what are cursors? : Sql server database administration

509


What is report snapshot?

99


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

858


How can we delete Duplicate row in table?

626


What are temporal tables in sql server 2016?

474


What is @@rowcount in sql?

552


Can primary key be a foreign key?

552