Which virtual table does a trigger use?

Answers were Sorted based on User's Feedback



Which virtual table does a trigger use?..

Answer / kmbkrishnan

Triggers use magic tables - Inserted and Deleted

updated or update table not available.

Is This Answer Correct ?    57 Yes 5 No

Which virtual table does a trigger use?..

Answer / lenin

Yes,Only inserted and deleted are available in SQL

Is This Answer Correct ?    23 Yes 6 No

Which virtual table does a trigger use?..

Answer / gourav

Inserted and Deleted.. right answer

what is updated....nonsence.

Is This Answer Correct ?    17 Yes 7 No

Which virtual table does a trigger use?..

Answer / nishita

inserted and deleted

Is This Answer Correct ?    9 Yes 4 No

Which virtual table does a trigger use?..

Answer / yoshita

DML triggers use the deleted and inserted logical
(conceptual) tables. They are structurally similar to the
table on which the trigger is defined, that is, the table
on which the user action is tried. The deleted and inserted
tables hold the old values or new values of the rows that
may be changed by the user action. For example, to retrieve
all values in the deleted table, use

Is This Answer Correct ?    5 Yes 3 No

Which virtual table does a trigger use?..

Answer / 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

Which virtual table does a trigger use?..

Answer / learner

triggers use 2 virtual tables called OLD and NEW.

Is This Answer Correct ?    5 Yes 22 No

Which virtual table does a trigger use?..

Answer / chandra rekha

Triggers use magic tables(update and delete tables)

Is This Answer Correct ?    9 Yes 35 No

Post New Answer

More SQL Server Interview Questions

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  


What is transaction server distributed transaction?

0 Answers  


Define ACID properties in a Database?

0 Answers   iNautix,


How to update a field in SQL after ALTERING a row?

0 Answers   Amdocs,


How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  






What is #table in sql server?

0 Answers  


Mention the differences between local and global temporary tables.

0 Answers  


write the query for taking database restore in sql?

2 Answers  


What is Command line parameters in PLSQL.?

0 Answers   MCN Solutions,


What is difference between primary key and foreign key?

0 Answers  


Can foreign key be duplicate?

0 Answers  


What is an sql server agent?

0 Answers  


Categories