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

How to update multiple rows with one update statement in ms sql server?

639


What is subquery in sql?

573


What is the sql case statement used for?

563


What is row-level compre?

549


What is the guest user account in sql server? What login is it mapped to it? : sql server security

588






What the different components of Replication and what is their use?

564


How to use old values to define new values in update statements in ms sql server?

687


How to use copy and concatenate commands in SQL?

603


Explain the phases a transaction has to undergo?

558


Does the order of columns in update statements matter?

482


Can we return Data from 4(more than 1) tables in stored procedure?

621


What are the limitations/drawbacks or ssrs 2008 r2?

86


What is the temp table?

548


How to insert data with null values?

594


Explain a differential backup?

576