What are Magic Table?
Answer Posted / krishna pada mandal
Whenever we fire the DML trigger in any table then the two
table is created one in inserted and second is deleted that
is called Magic table. Actually this is temporary table
inserted table contain the copy of all record that are
inserted in the trigger table. And deleted table contain all
records that have been deleted fro, the trigger table.
When we update the table the trigger use both the table.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between DELETE and TRUNCATE?
Can we insert data into a view?
What is a file group?
How many cores do I need for sql server 2016?
What is the difference between varchar and nvarchar?
Can we use custom code in ssrs?
What is mssql?
What is the difference between insensitive and scroll cursor?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What are the database roles? : sql server security
how you can configure a running aggregate in SSRS?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What are the types of table?
Can you get second highest salary from the table?
How to write character string constants or literals in ms sql server?