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?

How can I create a new template for import ? : sql server management studio

1084

---

List the data types available in mssql?

1043

---

What are the advantages of policy management?

1002

---

How do I find the query plan in sql server?

973

---

What is the function of inner join?

1082

---

Distinguish between nested subquery and correlated subquery?

1056

---

What is the difference between seek predicate and predicate?

1066

---

What is spid in sql server profiler?

1120

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1094

---

How to create a user name in a database?

1064

---

Does sql server use java?

1085

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

982

---

What is the difference between executequery () and executeupdate ()?

1052

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1175

---

What is the importance of three tier architecture?

1099

---