Answer Posted / nidhish

replace the N with wat ever number u want

select min(salary) from employee where salary in ( select
distinct top N salary from employee order by salary desc)

How to access the deleted record of an event?

571

---

What is the correct order of the logical query processing phases?

519

---

How to create a simple table to test triggers in ms sql server?

503

---

What is default port number for sql server 2000?

586

---

what's the information that can be stored inside a bit column? : Sql server database administration

523

---

---

Explain sql server authentication modes?

599

---

What is a non-clustered index?

555

---

Name and describe few console utilities for ssrs?

249

---

What are the database roles? : sql server security

555

---

What happens if you add a new index to large table?

504

---

Explain indexed views and partitioned view with their syntax.

676

---

List the different types of collation sensitivities in sql server?

520

---

what is checksum in sql server.........???

1198

---

Explain what is “asynchronous” communication in sql server service broker?

487

---

How to run sql server 2005 books online on your local system?

512

---