Answer Posted / justus

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a

select empname from emp group by empname having count(empname)>1

What is auditing in sql server?

965

---

How to include date and time values in sql statements?

1142

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1264

---

What are the ways available in sql server to execute sql statements?

1205

---

What are commit and rollback in sql?

1170

---

Where are sql server usernames and passwords stored in the sql server?

1171

---

What are Spatial data types in SQL Server 2008

1072

---

How will you decide the active and passive nodes?

1179

---

What is the process of normalising?

1045

---

What are the differences between stored procedure and the dynamic sql?

1137

---

What is the full meaning of dml?

998

---

How to create an multi-statement table-valued function?

1048

---

Will sql server 2005 allow you to reduce the size of a column?

1054

---

How to execute a stored procedure in ms sql server?

1251

---

What is the difference between dropping a database and taking a database offline?

1218

---