List few advantages of stored procedure.

981

---

What is the difference between locking and multi-versioning?

989

---

Differentiate between a local and a global temporary table?

954

---

Explain the collation?

1105

---

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

881

---

Describe how to use linked server?

1018

---

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

965

---

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

986

---

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

995

---

What is a trace frag?

1085

---

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

952

---

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

1098

---

Difference between drill down and drill through report.

952

---

What is openxml in sql server?

1168

---

What is replace and stuff function in sql server?

1065

---