List few advantages of stored procedure.

923

---

What is the difference between locking and multi-versioning?

938

---

Differentiate between a local and a global temporary table?

897

---

Explain the collation?

1043

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

838

---

Describe how to use linked server?

932

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

910

---

Give a example to search fr a string in all stored procedure in sql server.

911

---

Explain the etl (extraction, transformation, and loading)?

936

---

What is a trace frag?

1035

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

891

---

What is similarity and difference between truncate and delete in sql?

1028

---

Difference between drill down and drill through report.

900

---

What is openxml in sql server?

1109

---

What is replace and stuff function in sql server?

996

---