Which virtual table does a trigger use?

Question Posted / kaumil2001

3 Answers
8716 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which virtual table does a trigger use?..

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

Which virtual table does a trigger use?..

Answer / kapil

There are two virtual table
inserted and deleted

Is This Answer Correct ?

5 Yes

1 No

Which virtual table does a trigger use?..

Answer / sureshnaspuri

inserted and deleted

Is This Answer Correct ?

4 Yes

3 No

Post New Answer

More SQL Server Interview Questions

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers TCS, Wipro,

Write a sql query to get zero records from a table having n number of records?

0 Answers TCS,

mention different types of relationships in the dbms?

0 Answers

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers IBM,

What is named query? : sql server analysis services, ssas