What are Magic Table?
Answer Posted / subbu
suppose if we write a trigger on the table on insert or
delete or update
on insertion of record into that table,
inserted table will create automatically by database,
on deletion of record from that table,
deleted table will create automatically by database,
This two tables inserted and deleted are called magic
tables.
Is This Answer Correct ? | 29 Yes | 6 No |
Post New Answer View All Answers
Explain the collation?
What is the use of partition by in sql server?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What samples and sample databases are provided by microsoft?
What is the stuff and how does it differ from the replace function?
What is a full text index?
What is the default server name for sql server?
What is clr ddl trigger?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is tablesample?
Explain candidate key, alternate key, and composite key?
What are different types of subquery?
what are constraints? : Sql server database administration
How many triggers you can have on a table?