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

What is importing utility?

976

---

When would you use sql joins?

944

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

What is BLOCK statements in SQL?

1257

---

Explain temporary table vs table variable by using cursor alternative?

985

---

What is the difference between value type and reference type?

915

---

what are the different types of SSRS reports?

151

---

What guidelines should be followed to help minimize deadlocks?

936

---

When I run the sql server 2000 setup, it just hangs. What do I do?

1072

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

984

---

Tell me what is the order in which the sql query is executed?

942

---

What is optimization and its types?

961

---

How can you append an identity column to a temporary table?

941

---

What do you understand by a view? What does the with check option clause for a view do?

989

---

What do we need queues in sql service broker?

1059

---