Answer Posted / sabahuddin

Usually Inserted and Deleted Tables are called Magic Tables.Magic Tables does not contain the information about
the Columns of the DataType text,ntext or image.These are maintained by SQL Server for internal processing whenver an update,insert,Delete occur on table.However we can refer these tables in Triggers.
Whenever an updated table statement is fired SQL Server Maintains the original row before updation in a deleted table and New(Updated) row in inserted table.

How to encrypt Strored Procedure in SQL SERVER?

1119

---

What is “asynchronous” communication in sql server service broker?

978

---

What does truncate do?

895

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

946

---

Does partitioning improve performance?

927

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

977

---

Can an automatic recovery be initiated by a user?

953

---

Explain foreign key in sql server?

985

---

What is command parameter in ssrs?

157

---

Do you know sql server 2008 backup compression?

933

---

What is a result set object returned by odbc_exec()?

981

---

Explain DBCC?

925

---

Which autogrowth database setting is good?

1017

---

How can I add Reporting Services reports to my application?

129

---

Explain “@@rowcount” and “@@error” in sql server?

1022

---