Answer Posted / shailendra kashyap

Magic Tables:
Whenever a trigger fires in response to the
INSERT,DELETE,or UPDATE statement,two special tables are
created.These are the insert and the delete tables.They are
also referred to as the magic tables.These are the
conceptual tables and are similar in structure to the table
on which trigger is defined(the trigger table).
The inserted table contains a copy of all records that are
inserted in the trigger table.
The deleted table contains all records that have been
deleted from deleted from the trigger table.Whenever any
updation takes place,the trigger uses both the inserted and
deleted tables

What are the different types of replication are there in sql server 2000?

1007

---

How to execute function in stored procedure sql server?

1081

---

explain different types of cursors? : Sql server database administration

1047

---

Can two tables share a primary key?

971

---

How to find index size for each index on table?

979

---

Is there any difference between the primary key and unique key?

972

---

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

980

---

what is dbcc? : Sql server database administration

989

---

Can you explain what are commit and rollback in sql?

904

---

Explain system scalar functions?

971

---

How to use old values to define new values in update statements in ms sql server?

1204

---

Explain differentiate between a having clause and a where clause?

866

---

What are the mathematical functions supported by sql server 2005?

1015

---

Do you know what are the ways available in sql server to execute sql statements?

990

---

Where the sql logs gets stored? : sql server database administration

926

---