Answer Posted / hari

Cursor : Curosr is allow row processing of the result set.
Static
Dynamic
forward-only
Key setdriven

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

582

---

What is TDS(Tabular Data Stream) Gateway?

99

---

Name few endpoints exposed by ssrs 2012?

305

---

What is the difference between lock, block and deadlock? : sql server database administration

574

---

How to enable tcp/ip protocol on a sql server?

592

---

---

How to change the ownership of a schema in ms sql server?

563

---

How to divide query output into multiple groups with the group by clause in ms sql server?

573

---

How to create median function?

118

---

how to trace the traffic hitting a sql server? : Sql server database administration

1144

---

What is the default port for SQL Server over a firewall?

593

---

What are the different types of indexes?

613

---

What is the full form of dql?

517

---

How to execute a sql statement using odbc_exec()?

574

---

what is the main function of a query parameter?

111

---

Explain how you can configure a running aggregate in SSRS?

111

---