Answer Posted / sivasiva

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a
select empid from emp groupby empid,empname having count>1

Why we use the openxml clause?

971

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1060

---

What does indexation mean?

932

---

How to create a local temporary stored procedure?

967

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2444

---

What is updatable resultset?

960

---

what are user defined datatypes and when you should go for them? : Sql server database administration

978

---

How can you list all the table constraints in a database?

897

---

What is function of ROLLUP ?

1057

---

How to store and query spatial data?

953

---

How to select some specific columns from a table in a query in ms sql server?

963

---

What is a filestream?

954

---

What is difference between clustered index and non clustered index?

1042

---

why would you use sql agent? : Sql server database administration

1145

---

optimization techinques

2647

---