Answer Posted / anija

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary

What are the steps to process a single select statement?

990

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1062

---

Can a synonym name of a table be used instead of a table name in a select statement?

1093

---

How to access the deleted record of an event?

1092

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

997

---

Find columns used in stored procedure?

1039

---

How to reaname table name without using sp_Rename in sql server..?

1041

---

What is the security model used in sql server 2005?

1071

---

Differentiate sql server reporting services vs. Crystal reports?

209

---

what is bit datatype? : Sql server database administration

963

---

Name three of the features managed by the surface area configuration tool? : sql server security

1034

---

What is save transaction and save point?

1258

---

What is cdc in sql server?

1046

---

What is function of master database?

117

---

Why olap is used?

1036

---