What are Magic Table?
- 34 Answers
- 73520 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
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
How to get a list of columns in a view using "sys.columns" in ms sql server?
Explain magic tables in sql server?
How global temporary tables are represented and its scope?
What is outer join in sql server joins?
What is equi join with example?
what is a self join? : Sql server database administration
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What is the filtered index?
What is the difference between Stored Procedures and triggers?
Explain in brief how sql server enhances scalability of the database system?
Define cursor locking
How to truncate the log in sql server 2012? : sql server database administration
What are SSL and TSL protocols?
Explain the microsoft sql server delete command?
What is the difference between an index and a unique index?
