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 database architecture? : SQL Server Architecture

0 Answers  

---

How to delete duplicate rows?

0 Answers  

---

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

---

What is the server name in sql server?

0 Answers  

---

what is datawarehouse?

0 Answers   Informatica,

---

What is the definition for sql server 2000?

0 Answers  

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

---

How to find the date and time of last updated table?

3 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

How to get nth highest salary from employee table.

0 Answers  

---