What are Magic Table?
Answer Posted / imran badrampalli
There are 2 Magic Tables in SQL server Inserted and Deleted.
These are mantained by SQL server for Internal processing
whenever an update, insert of delete occur on a table.
However, we can refere these tables in a Trigger.
Whenever an update table statement is fired SQL server
mantains the original row before updation in a deleted
table and New (updated )row in a Inserted Table.
Same is the case when an insert is fired Only Inserted
table is populated with inserted Row.
and when Delete table statement is fired Deleted table is
populated with the deleted row.
Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is the bookmark lookup and rid lookup?
Are connections to sql server encrypted?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is the Main Difference between ACCESS and SQL SERVER?
How do I find the port number for sql server?
What number sorts of privileges are accessible in sql?
When I delete any data from a table, does the sql server reduce the size of that table?
What are the kinds of subquery?
How do you open a cluster administrator?
Can you import Microsoft Excel data to SSRS?
Can we use pragma autonomous_transaction in trigger?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is table valued function and scalar valued functions?
What are sql server functions?
Do you know what is normalization of database? What are its benefits?