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
How many clustered indexes there can be on table ?
what is package and it uses and how can u call a package
How to set database to be single_user in ms sql server?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
what is sql server? : Sql server database administration
whats the maximum size of view state??
What is a view and what are its advantages?
Define msdb database?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is global temp table?
What are difference between Cluster index and Non-Cluster index?
How to reaname table name without using sp_Rename in sql server..?
Explain the collation?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Can you pass expressions to stored procedure parameters?