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

How can I get data from a database on another server?

933

---

Can you explain the disadvantages/limitation of the cursor?

906

---

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

103

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

862

---

What are logical/boolean operations in ms sql server?

978

---

How to provide default values to function parameters?

1050

---

What are the properties of primary key?

913

---

How do I find the query plan in sql server?

907

---

What do you mean by collation recursive stored procedure?

1010

---

Do you know the cursor optimization tips?

930

---

is there a column to which a default can't be bound? : Sql server database administration

967

---

How to set the current database in ms sql server?

1009

---

Does union all remove duplicates?

1016

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1800

---

Explain the advantages of merge replication?

893

---