List few advantages of stored procedure.

981

---

What is the difference between locking and multi-versioning?

985

---

Differentiate between a local and a global temporary table?

951

---

Explain the collation?

1104

---

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

879

---

Describe how to use linked server?

1013

---

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

964

---

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

982

---

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

993

---

What is a trace frag?

1083

---

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

946

---

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

1097

---

Difference between drill down and drill through report.

949

---

What is openxml in sql server?

1164

---

What is replace and stuff function in sql server?

1061

---