Answer / punit chauhan

whenever a trigger is fire in response to an insert, delete and update statement.
Two special tables create, these are the inserted and deleted tables, they are also referred as magic tables.

* whenever we insert any record into the table then trigger use inserted table.

* whenever we delete any record into the table then trigger use deleted table.

* whenever we update any record into the table then trigger use inserted and deleted tables.

Answer / rani

Refer this link which nicely demonstrates the Magic Table.
Magic Table are the INSERTED and DELETED tables which we
cannot see from the database, but can be accessed using
Triggers.
When a new row is added an INSERTED table gets created with
the inserted row. Similarly when a row is updated a DELETED
table is created with the deleted row. For update the old
data is moved to the DELETED table and the new updated row
gets created in the INSERTED table.

What is b tree index?

0 Answers  

---

Do you know sql server 2008 backup compression?

0 Answers  

---

What are examples of triggers?

0 Answers  

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

0 Answers  

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

How to find the last update record in SQL Server?

4 Answers  

---

Why union all is faster than union?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

What is an indexing technique?

0 Answers  

---

What are the different types of triggers in SQL SERVER?

0 Answers  

---

How would you choose between a clustered and a non-clustered index?

0 Answers  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---