Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 78734 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
Why truncate is ddl?
How to convert a unicode strings to non-unicode strings?
what are the critical issues you have resloved in your company
What is the tcp/ip port on which sql server runs?
What are the filtered indexes?
Tell me about builtinadministrator?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is difference between clustered index and non clustered index?
What command do we use to rename a db, a table and a column?
How to create a new table in a given schema?
where can you add custom error messages to sql server? : Sql server administration
Describe in brief authentication modes in sql server.
What is data compression? : sql server database administration
Explain raiserror in sql server?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
