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.

Define self join in sql server joins?

0 Answers  

---

What is @@rowcount in sql?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

Can a rule be bound to any column of any data type?

0 Answers  

---

When would you use a before or after trigger?

0 Answers  

---

How to test odbc dsn connection settings?

0 Answers  

---

What is a cube? : sql server analysis services, ssas

0 Answers  

---

How to use clusters?

0 Answers   Amdocs,

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

How do you create a clustered index?

0 Answers  

---

How is foreign key related to primary key?

0 Answers  

---

How many types of the database links?

0 Answers   MCN Solutions,

---