Answer Posted / maya

While using triggers these Inserted & Deleted tables
(called as magic tables) will be created automatically.

When we insert any record then that record will be added
into this Inserted table initially, similarly while
updating a record a new entry will be inserted into
Inserted table & old value will be inserted into Deleted
table.

In the case of deletion of a record then it will insert
that record in the Deleted table

How to list all stored procedures in the current database using ms sql server?

1054

---

What are the basic features of a trigger in ms sql server?

1109

---

How to replace null values in expressions using isnull()?

1050

---

List some of the rules that apply to creating and using a ‘view’

814

---

Explain DBCC?

908

---

What is check constraint in sql server?

955

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2667

---

explain declarative management framework (dmf) in sql server 2008?

949

---

What are the new features are introduced in sql server 2012 reporting services?

143

---

what's the difference between a primary key and a unique key? : Sql server database administration

892

---

Give me any three differences between Truncate and Delete.

1041

---

How to change the system date and time from SQL Plus Terminal ?

1152

---

How to drop an existing table?

958

---

Difference between connected and disconnected database in .net with sql server?

1034

---

What is the difference between dbcc indexdefrag and dbcc reindex?

930

---