What are Magic Table?

Answer Posted / puneet sharma

INSERTED and DELETED tables known as MAGIC
TABLES.BECAUSE IN BOTH THE CASES TRIGGER FIRES AND
TEMPORARILLY STORE INSERTED AND DELETED VALUES
RESPECTIVELLY.

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 cursors? And what are the different types of cursor?

553


Which tools are available to manage SQL Azure databases and servers?

93


How do you rename a table in sql server?

490


Define views.

588


What do you mean by data integrity?

597






What are the requirements for sql server 2016?

536


What is sql server locking?

553


What is the server name in sql server?

555


Explain primary key and foreign key constraints?

522


Why olap is used?

561


How to make remote connection in database?

594


Explain what is cte (common table expression)?

624


is it important for a database administrator to understand the operating system and file access? : Sql server administration

583


Can you explain various data region available in ssrs with their use?

548


What are the parts of a function?

521