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
What is cursors? And what are the different types of cursor?
Which tools are available to manage SQL Azure databases and servers?
How do you rename a table in sql server?
Define views.
What do you mean by data integrity?
What are the requirements for sql server 2016?
What is sql server locking?
What is the server name in sql server?
Explain primary key and foreign key constraints?
Why olap is used?
How to make remote connection in database?
Explain what is cte (common table expression)?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Can you explain various data region available in ssrs with their use?
What are the parts of a function?