Can we use having clause without group by?

0 Answers  

---

What is DAC? what is the use of it?

1 Answers   Wipro,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

How do you read transaction logs

1 Answers  

---

What is the difference between locking and multi-versioning?

0 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

Explain aggregate functions?

0 Answers  

---

Can binary strings be converted into numeric or float data types?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

Can a database be shrunk with users active?

0 Answers  

---

What is key set driven?

0 Answers  

---