Which virtual table does a trigger use?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the functionalities that views support?

853


Explain the xml support sql server extends?

809


Please explain what is “asynchronous” communication in sql server service broker?

690


Tell me what are the advantages of using stored procedures?

743


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

705






What are the new features are introduced in sql server 2012 reporting services?

121


Explain subquery and state its properties?

701


Are all views updatable ?

892


How to create a new table in a given schema?

840


State a few properties of relational databases?

833


What are different types of join?

950


You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

292


How to search for a string in all stored procedure in sql server?

736


Tell me about pre-defined functions of sql?

859


What Are the Main Features of SQL Azure?

109