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"

How to check if stored procedure is running in sql server?

959

---

Explain primary key and foreign key constraints?

962

---

What is a transaction and why is it important?

997

---

How do you delete duplicate records in sql server?

991

---

which backup strategy you are following at ur company

2103

---

How can we check the sql server version?

980

---

How to stop log file growing too big?

953

---

How to view the error log for any specific instance? : sql server database administration

984

---

What is @@rowcount in sql?

948

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2332

---

What is the language structure to add a record to a table?

961

---

What is used to replicate sessions between instances in coldfusion clusters?

1014

---

Can we deploy SSRS reports on our personal website?

162

---

How do I partition a table in sql server?

982

---

What is database dimension? : sql server analysis services, ssas

1030

---