Answer Posted / anil sharma

In sqlserver 2000 we must use a unique id per row then we
can delete duplicate rows.

delete from <tablename> where <rowid> not in (select min
(<rowid> from <tablename> group by co1,col2.)


But in sqlserver 2005 there a function RowId.Which is same
as above concept.It return unique id per row.

How to use go command in "sqlcmd"?

1196

---

What is transaction server distributed transaction?

1046

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

944

---

How to get a list of columns using the "sys.columns" view in ms sql server?

954

---

Which are the two editions in which SQL Azure database available?

119

---

Explain “not null constraint” in sql server?

1023

---

How do I edit a procedure in sql server?

948

---

What is the difference between migration and upgradation in sql server?

1090

---

What is data block and how to define data block size?

1016

---

Can group functions be used in the order by clause in ms sql server?

1009

---

What is an index in sql?

996

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1000

---

Explain how does the report manager work in ssrs?

948

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1041

---

Explain log shipping and mention its advantages.

1038

---