List few advantages of stored procedure.

1026

---

What is the difference between locking and multi-versioning?

1038

---

Differentiate between a local and a global temporary table?

998

---

Explain the collation?

1146

---

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

938

---

Describe how to use linked server?

1077

---

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

1013

---

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

1063

---

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

1052

---

What is a trace frag?

1134

---

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

1003

---

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

1152

---

Difference between drill down and drill through report.

1003

---

What is openxml in sql server?

1219

---

What is replace and stuff function in sql server?

1113

---