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

Where are SQL server users names and passwords are stored in sql server?

1320

---

What are the different sql server versions?

1028

---

What are the differences between union, intersect, and minus operators?

1134

---

Define full outer join in sql server joins?

1040

---

What to perform pattern match with the like operator?

926

---

What is logshipping and its purpose?

1060

---

Tell me what are cursors and when they are useful?

993

---

What are the differences between sql server and mysql.

1133

---

List out a number of the wants to setup a SQL Server failover cluster?

1115

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1097

---

do you know how to configure db2 side of the application? : Sql server database administration

1087

---

How do I save a stored procedure in sql server?

1039

---

How adventureworkslt tables are related?

977

---

How to generate create view script on an existing view?

1032

---

What you can do to delete a table without the delete trigger firing?

1010

---