Answer Posted / eashwar v

IN SQL SERVER 2005, This can be easily achieved without
crating unique identifier by using CTE and ROW_NUMBER (),
the modified query for sql server 2005 goes here
***********************************************
WITH T1 AS (SELECT ROW_NUMBER ( ) OVER ( PARTITION BY ID,
FNAME, LNAME ORDER BY ID ) AS RNUM FROM DUPLICATE )
DELETE FROM T1 WHERE RNUM > 1
***********************************************
To get a detail grasp on ROW_NUMBER () OVER () … Refer MSDN
http://msdn2.microsoft.com/en-us/library/ms186734.aspx for.

Determine how to use the inserted and deleted pseudo tables?

1038

---

How do I find the port number for sql server?

1013

---

What is #temp and @table variable in SQL server?

1136

---

What is the dbcc command and why is it used?

1105

---

What is the difference between NOROW and LOCKROW?

2899

---

What is the standby server?

998

---

What are the advantages of using cte?

1072

---

List the different index configurations possible for a table?

975

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1110

---

How do you rebuild an identity column?

994

---

What is oltp (online transaction processing)?

1055

---

Can we shrink data file in sql server?

1090

---

What is table level trigger?

1052

---

What is postgresql server?

1054

---

How to send email from database?

1069

---