Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77584 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / aastha pallav
Sometimes we need to know about the data which is being
inserted/deleted by triggers in database. With the
insertion and deletion of data, tables named “INSERTED”
and “DELETED” gets created in SQL Server which contains
modified/deleted data.
Here, “INSERTED” and “DELETED” tables are called magic
tables.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Define ACID properties in a Database?
how to invoke a trigger on demand? : Sql server database administration
Will the writetext statement activate a trigger?
explain different types of cursors? : Sql server database administration
How does the report manager work in SSRS?
What is the report model project?
What is a heap?
How do I view a script in sql server?
Name some of the open source software that you can use in alternative to SSR?
How do I find the default sql server instance?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is a transaction and why is it important?
What do you mean by an execution plan? Why is it used? How would you view it?
What does the on update no action do?
What are clustered and non-clustered index?
