Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 79640 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 the dbcc command and why is it used?
What is bcp? When does it used?
How do I find the port number for sql server?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is a virtual table in sql?
What is difference between unique and primary key?
How to choose all records from the table?
What is the beast way to write CTE in SQL Server ?
Define union, union all, minus, intersect?
How to maintain a fill factor in existing indexes?
between cast and convert which function would you prefer and why?
What are examples of triggers?
What do I need to start working with sql studio? : sql server management studio
What is meant by dirty read?
How to retrieve field values using mssql_result()?
