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


Please Help Members By Posting Answers For Below Questions

What is the purpose of sql profiler in sql server? : sql server database administration

602


Does any body please help me what question's have asked for SSRS in the interview?

1649


What is ems sql management studio? : sql server management studio

561


what is new philosophy for database devises for sql server 7.0? : Sql server database administration

496


Do you know the different ddl commands in sql?

568






What are the different types of data sources in ssrs?

142


How to update muliple row in single query?

591


Can you explain the disadvantages/limitation of the cursor?

485


How to create median function?

116


what is the different types of backups available in sql server? : Sql server database administration

477


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

610


What is unpivot?

549


What is faster join or union?

575


Why do we use functions?

491


How can you set the threshold at which sql server will generate keysets asynchronously?

542