Answer Posted / mohan c v

select min(salary) from
(select top 2 salary from emp order by salary desc) as a

When do you think a developer should use sql server-based cursors?

512

---

Can another user execute your local temporary stored procedures?

531

---

What is indexing a document?

539

---

What is nonclustered index on computed columns?

566

---

Define union, union all, minus, intersect?

553

---

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

640

---

How and why use sql server?

532

---

What is data compression?

539

---

Explain foreign key in sql server?

566

---

What is the difference between indexing and hashing?

537

---

what is difference between view and Dip.

1987

---

What is exclusive locks?

531

---

What is sql server programming?

536

---

What are various ways to enhance the ssrs report?

522

---

Why we need sql server?

546

---