Which virtual table does a trigger use?
Answers were Sorted based on User's Feedback
Answer / kmbkrishnan
Triggers use magic tables - Inserted and Deleted
updated or update table not available.
Is This Answer Correct ? | 57 Yes | 5 No |
Answer / lenin
Yes,Only inserted and deleted are available in SQL
Is This Answer Correct ? | 23 Yes | 6 No |
Answer / gourav
Inserted and Deleted.. right answer
what is updated....nonsence.
Is This Answer Correct ? | 17 Yes | 7 No |
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 |
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 |
Answer / learner
triggers use 2 virtual tables called OLD and NEW.
Is This Answer Correct ? | 5 Yes | 22 No |
Triggers use magic tables(update and delete tables)
Is This Answer Correct ? | 9 Yes | 35 No |
Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key
What is transaction server distributed transaction?
Define ACID properties in a Database?
How to update a field in SQL after ALTERING a row?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is #table in sql server?
Mention the differences between local and global temporary tables.
write the query for taking database restore in sql?
What is Command line parameters in PLSQL.?
What is difference between primary key and foreign key?
Can foreign key be duplicate?
What is an sql server agent?