What are Magic Table?
- 34 Answers
- 80317 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / digvijay kumar singh
Magic table is Temporary type table. it is created when
trigger perform the insert,delete and update action. trigger
have two type magic table:-
1:- inserted table.
2:- deleted table.
when trigger perform the insert and update action on table
then trigger used the Inserted magic table and deleted magic
table used at deletion time.
i hope you will understand..................
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why we use the openxml clause?
Disadvantages of the indexes?
What are the different SQL Server Versions you have worked on?
List out the different types of locks available in sql server?
When should you use an instead of trigger?
How raid can influence database performance?
How do I find query history in sql server?
Where can you add custom error messages to sql server?
What is in place upgrade in sql server?
what is spatial nonclustered index
How to convert character strings into numeric values?
What are the properties of the transaction?
Why should you use or avoid select * statements?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Is it possible to have clustered index on separate drive from original table location?
