Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77947 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
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 a join? : Sql server database administration
What is the difference between grant and with grant while giving permissions to the user?
What are the different type of replication in sql server?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How to see the event list of an existing trigger using sys.trigger_events?
What is function of ROLLUP ?
What are the database objects? : SQL Server Architecture
How to concatenate two character strings together?
What is the default fill factor value?
Explain different types of collation sensitivity?
What is the sql case statement used for?
Explain in brief how sql server enhances scalability of the database system?
What is the default value of an integer data type in sql server 2005?
What is a trigger what are the advantages of trigger?
How to create a trigger for insert only?
