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 a data collection table?

0 Answers  

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  

---

What is pessimistic concurrency?

0 Answers  

---

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  

---

What is the primary use of the model database?

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,

---

Is truncate autocommit?

0 Answers  

---

What do we have to check in database testing?

0 Answers  

---

What to perform pattern match with the like operator?

0 Answers  

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---