Answer Posted / chandra sekhar

select min(salary) from emp where salary in (select top n salary from emp order by salary desc)

How to select some specific rows from a table in ms sql server?

974

---

How can you know if the row fetched from cursor is still valid in underlying table?

969

---

Explain different types of lock modes in sql server 2000?

903

---

What is the security principal at the server level that represents your session?

984

---

What are the rendering extensions of ssrs?

146

---

Why truncate is ddl?

1046

---

What are secondary xml indexes?

998

---

How can you ensure that the database and sql server based application perform well?

1035

---

what protocol both networks use? : Sql server database administration

946

---

Can group by be used without aggregate functions?

875

---

What is the tcp/ip port on which sql server runs?

1096

---

What is partitioned view?

872

---

How much is a sql server license?

923

---

What is 1nf normalization form?

996

---

What causes index fragmentation?

961

---