What are Magic Table?
- 34 Answers
- 73495 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar
Whenever a trigger is fired in response to the
INSERT,DELETE,Or UPDATE statement the SQL SERVER creates
two temporary tables, Called Magic Table. The Magic Table
called inserted or deleted. The magic table conceptual
tables are similar in structure to the table on which thw
trigger is difined.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Which tcp/ip port does sql server run on? How can it be changed?
What is an indexed view?
What is read uncmmited?
How can you hide the sql server instances?
Mention the differences between local and global temporary tables.
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Is INSTEAD OF trigger directly applicable to Table ?
What are the three different part of rdl file explain them?
Is a primary key unique?
What is repeatable read?
What is the difference between varchar and nvarchar?
What are the advantages dts has over bcp?
What do you mean by cardinality?
What is join query?
