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

What does sql server mean?

1161

---

Explain how to integrate the ssrs reports in application?

1063

---

What happens if null values are involved in bitwise operations?

1078

---

What is explicit mode in sql server?

1109

---

What is fill factor and pad index?

1060

---

What are the joins in sql server? : sql server database administration

1050

---

Can two tables share a primary key?

1079

---

Explain transaction server explicit transaction?

971

---

Explain what is it unwise to create wide clustered index keys?

1023

---

What is an execution plan? How would you view the execution plan?

1129

---

What is the difference between substr and charindex in the sql server?

1185

---

Write a sql query to sort on different column name according to the parameters passed in the function?

961

---

What are null values in ms sql server?

1142

---

Explain what are the restrictions while creating batches in sql server?

1114

---

What do you mean by normalisation?

1102

---