Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77637 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
How do I find the port number for sql server?
What is the difference between varchar and nvarchar datatypes?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Can an entity have two primary keys?
What is the purpose of the model database?
Tell me what is fill factor?
Explain what are the database objects? : SQL Server Architecture
What part does database design plays a role in performance of an sql server-based application?
Explain about integration services of Microsoft SQL server?
What is difference between clustered index and non clustered index?
What do you mean by an execution plan?
What do you mean by an execution plan? Why is it used?
Do you know what is rank function?
How do I port a number to sql server?
What is the difference between char, varchar and nvarchar?
