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

How to convert a table data in XML format in sql server?

2545

---

Can you explain about buffer cash and log cache in sql server?

952

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1039

---

What do you mean by cardinality?

903

---

What are cursors in ms sql server?

1183

---

How you can find out if an index is useful to the optimizer?

941

---

How to find the service pack installed? : sql server database administration

1023

---

What is filtered index?

1100

---

Is it possible to update the views? If yes, how, if not, why?

1031

---

How would you choose between a clustered and a non-clustered index?

979

---

What is proper subset of candidate key?

998

---

How do I make a resultset scrollable?

966

---

What is difference between inner join and full join?

1070

---

In case you have filters in your report, when filters will be applied in cached report instance?

113

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

6894

---