Answer Posted / imran badrampalli

There are 2 Magic Tables in SQL server Inserted and Deleted.
These are mantained by SQL server for Internal processing
whenever an update, insert of delete occur on a table.
However, we can refere these tables in a Trigger.
Whenever an update table statement is fired SQL server
mantains the original row before updation in a deleted
table and New (updated )row in a Inserted Table.

Same is the case when an insert is fired Only Inserted
table is populated with inserted Row.
and when Delete table statement is fired Deleted table is
populated with the deleted row.

What is the data type of time?

910

---

Is BCNF better than 2NF & 3NF? Why?

1002

---

Explain differences between web edition and business edition?

119

---

Can I work with several databases simultaneously? : sql server management studio

943

---

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

115

---

What is snapshot replication?

998

---

What is an sql server agent?

995

---

Why do we use stored procedures in sql server?

895

---

How to create new table with "create table" statements?

995

---

What are the tables in sql?

1038

---

what is the primary use of the model database? : Sql server administration

963

---

How to count groups returned with the group by clause in ms sql server?

1006

---

What is a deadlock and what is a live lock?

951

---

How to loop through the result set with @@fetch_status?

1251

---

What is data source document?

979

---