Answer Posted / maya

While using triggers these Inserted & Deleted tables
(called as magic tables) will be created automatically.

When we insert any record then that record will be added
into this Inserted table initially, similarly while
updating a record a new entry will be inserted into
Inserted table & old value will be inserted into Deleted
table.

In the case of deletion of a record then it will insert
that record in the Deleted table

What is data compression? : sql server database administration

968

---

What is meant by datasource?

922

---

What is the advantage of sql server?

1032

---

what are the different ways to return the rowcount of a table?

999

---

Determine when an index is appropriate?

1076

---

How each E-R model constructs can be mapped to the relational model?

1001

---

Which joins are sql server default?

1007

---

How can you insert null values in a column while inserting the data?

1280

---

What is the order in which the sql query is executed?

942

---

What are date and time data types in ms sql server?

1090

---

Can the “if update (colname)” statement be used in a delete trigger?

990

---

In what sequence sql statement is processed?

1012

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1022

---

How to add a new dsn with the odbc driver for sql server?

1060

---

How to check status of stored procedure in sql server?

985

---