Which virtual table does a trigger use?

Answer Posted / kapil

There are two virtual table
inserted and deleted

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is compression - row-level and page-level compression?

528


Explain how would you store your query in an SSRS report or a Database server?

90


Explain an incremental backup?

589


Explain insert into select statement?

523


What is @@rowcount in sql?

554






What is difference between commit and rollback when used in transactions?

496


Tell me extended events in sql server 2008?

557


What is the synonym of join?

518


How do I partition a table in sql server?

535


What is function of ROLLUP ?

652


What is page in sql server?

513


Does a specific recovery model need to be used for a replicated database? : sql server replication

529


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

568


How do triggers work?

536


What is subquery? Explain the properties of a subquery?

507