What are Magic Table?
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
What does Master database contains?
Can the “if update (colname)” statement be used in a delete trigger?
What command would you use to create an index?
What are different types of join?
Write a query for primary key constraint with identity key word?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain relational data?
Explain filtered indexes?
What is the difference between index seek vs. Index scan?
What is precedence constraint?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
How real and float literal values are rounded?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
How to list all login names on the ms sql server?
Disadvantages of the indexes?