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
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Explain how to send email from sql database?
What are trace files?
What are the filtered indexes?
Can you get second highest salary from the table?
How to get the definition of a view out of the sql server?
Explain what you mean by 3 tier architecture.
In which files does sql server actually store data?
what is the difference between Tabular and Matrix report?
What is the difference function and stored procedure?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What does dml stand for?
What were the latest updates to SQL Azure service?
what is the system function to get current user's user id? : Sql server database administration
What are the 2 types of classifications of constraints in the sql server?