What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

Explain full-text query in sql server?

0 Answers  

---

What is filestream?

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

---

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

0 Answers  

---

Explain trigger and trigger types?

0 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

---

What options are available to audit login activity? : sql server security

0 Answers  

---

What is indexed views? plz explain with example?

2 Answers  

---