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.

What is BLOCK statements in SQL?

1310

---

What are the different types of cursor?

1147

---

When you should use a low fill factor?

1035

---

What is shrink log file?

950

---

How to use linked server?

1269

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1110

---

Can we call stored procedure in trigger?

996

---

Define Business Edition in SQL Azure?

102

---

List all the types of user-defined functions?

1180

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1028

---

can we have a nested transaction? : Sql server database administration

1188

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1085

---

What is open database communication (odbc)?

1112

---

How to create a ddl trigger using "create trigger" statements?

1185

---

How to make conditional sum in ssrs?

183

---