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.

What is nolock hint in sql server 2008

1130

---

What is normalization 1nf 2nf 3nf?

1064

---

What is blocking?

1074

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

154

---

How to rebuild the master database?

1083

---

How to disable a login name in ms sql server?

1138

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2511

---

What is the bookmark lookup and rid lookup?

998

---

Tell me what do we need queues in sql service broker?

998

---

What is function of CUBE ?

1050

---

What are the benefits of filtered indexes?

1042

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1047

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

---

what is the difference between a primary key and a unique key? : Sql server database administration

1010

---

How to find the second highest salary of an employee?

1183

---