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 do I need to start working with sql studio? : sql server management studio
How can you list all the table constraints in a database?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
How to change the ownership of a schema in ms sql server?
How would you go about developing a ssrs report?
What is the difference between cartesian product and cross join?
What is difference between delete & truncate commands?
Where actually sql azure database is hosted?
Explain isolation levels that sql server supports?
What are the 7 disadvantages to a manual system?
explain different levels of normalization? : Sql server database administration
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
What is the parse query button used for?
How to create function without parameter in sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many