Which virtual table does a trigger use?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / guest

8 Answers
27650 Views
TCS, I also Faced
E-Mail Answers

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