What are Magic Table?
Answer Posted / yogesh
You all have answered what magic tables are. its correct :
there are two magic tables named inserted and deleted.
On Insertion :
whenever an insert takes place, the data goes into inserted
table before the commit of the transaction.
On Deletion :
Whenever a row gets deleted from a table, data goes into
deleted table.
On Update :
Since an update statement is a combination of delete and
insert so in case of update data goes in both, inserted and
deleted tables.
But the further Question is :
How the magic tables get created by ASE? Can any one give
the detailed and satisfactory answer?
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of sql profiler in sql server? : sql server database administration
Does any body please help me what question's have asked for SSRS in the interview?
What is ems sql management studio? : sql server management studio
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
Do you know the different ddl commands in sql?
What are the different types of data sources in ssrs?
How to update muliple row in single query?
Can you explain the disadvantages/limitation of the cursor?
How to create median function?
what is the different types of backups available in sql server? : Sql server database administration
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is unpivot?
What is faster join or union?
Why do we use functions?
How can you set the threshold at which sql server will generate keysets asynchronously?