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 does truncate do?

0 Answers  

---

What is difference between standardization and normalization?

0 Answers  

---

What are the properties of the transactions?

0 Answers  

---

What is meant by indexing?

0 Answers  

---

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

3 Answers  

---

What are the methods used to protect against sql injection attack?

0 Answers  

---

Does the unique constraint create an index?

0 Answers  

---

How the data stores in a page?

1 Answers  

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  

---

How do you drop an index?

0 Answers  

---

How do I setup a local sql server database?

0 Answers  

---