Answer Posted / ruchita

Adv:cursor is a private sql area in which
row by row operatioms and validations can be done
disadv:resource reqired are more

How to create an multi-statement table-valued function?

998

---

How to resolve the orphan use problem? : sql server security

1015

---

Why use “nolock” in sql server?

1059

---

what purpose does the model database serve? : Sql server database administration

982

---

What is the difference between a "where" clause and a "having" clause?

1160

---

How to retrieve error messages using mssql_get_last_message()?

1054

---

How to test values returned by a subquery with the in operator?

1197

---

How many partitions a clustered index has by default in sql server 2012?

1089

---

What is model database? : SQL Server Architecture

1133

---

What are the different ways you can create databases in sql server?

1106

---

What happens to a statement batch if there is a compilation error?

969

---

Does server sql treat char as a variable-length or fixed-length column?

1035

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

988

---

Explain the ways to controlling cursor behavior?

919

---

how to overcome kernel isssues

1626

---