Which virtual table does a trigger use?

Answer Posted / bharathi

Answer is deleted and inserted

INSERT Trigger populates inserted table
DELETE Trigger populates deleted table
UPDATE Trigger poulates both inserted and deleted tables

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can two tables share a primary key?

734


role of sql sever 2005 in database rather than any other database

1745


What do you think of this implementation? Can this be implemented better?

719


What happens if null values are involved in bitwise operations?

822


How global temporary tables are represented and its scope?

737


What is the significance of master, tempdb and model databases?

756


How to add additional conditions in SQL?

787


What does normalization do to data?

751


What is the difference between clustered and a non-clustered index?

790


Explain an incremental backup?

765


What is db stored procedure?

638


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

779


Differentiate between a having clause and a where clause.

712


What is a covered index?

723


What is plan freezing?

737