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 are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

---

What are types of scd? : sql server analysis services, ssas

0 Answers  

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

can an order by clause be used in a creation of a view?

0 Answers  

---

What does the update command do?

0 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

Explain what is lock escalation?

0 Answers  

---

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

---

What is the difference between count () and rowcount ()?

0 Answers  

---