Answer Posted / deepak dabi

I Think this is the best solution ever i have seen ,i
appriciate if you prove me wroong on this so,otherwise i got
all other a bit wrong ,in many cases please try this....



"SELECT distinct(sal) from emp order by sal desc limit 2,1"

What is nolock hint in sql server 2008

1098

---

What is the purpose of forms?

921

---

What is clustered primary key?

978

---

What is user-defined function?

932

---

Give the query of getting last two records from the table in SQL SERVER?

917

---

What are the different authentication modes in sql server? How can it be changed?

1049

---

Working with TLogs

1805

---

How can delete duplicate records in cte in sql server?

925

---

Does sql server 2000 full-text search support clustering?

834

---

How we can compare two database data?

896

---

What type of locking occurs during the snapshot generation? : sql server replication

1294

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1183

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

143

---

What are system databases into sql server (2005/2008)?

976

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

911

---