Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 78701 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
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
When we should use @@error?
What are types of scd? : sql server analysis services, ssas
What is sql server query analyzer?
What does Master database contains?
What is bit data type?
What are data resources?
What is the difference between rank and dense_rank?
Do you know sql server 2008 backup compression?
Explain what is the difference between a local and a global temporary table?
What are the basic features of a trigger in ms sql server?
How can we improve performance by using SQL Server profiler?
How to set a database state to offline in ms sql server?
What are binary string data types in ms sql server?
What is transaction server explicit transaction?
How to create percentile function?
