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 |
Is port 1433 secure?
Why should we go for stored procedures? Why not direct queries?
How to determine the service pack currently installed on SQL Server?
Explain different backup plans?
Explain indexed view?
What is Cross Join and in which scenario do we use Cross Join?
What are truncate options available in sql server? : sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What do you understand by a view?
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
Is truncate autocommit?
DIFFERENCE BETWEEN SQL SERVER 2005 and 2008