Answer Posted / mohit d jethva

///////////Cursor for delete duplicate record in
table//////////

DECLARE @ID int
DECLARE @NAME NVARCHAR(50)
DECLARE @COUNT int

DECLARE CUR_DELETE CURSOR FOR
SELECT [ID],[NAME],COUNT([ID]) FROM [Example] GROUP BY [ID],
[NAME] HAVING COUNT([ID]) > 1

OPEN CUR_DELETE

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
/* Loop through cursor for remaining ID */
WHILE @@FETCH_STATUS = 0
BEGIN

DELETE TOP(@COUNT -1) FROM [Example] WHERE ID = @ID

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
END

CLOSE CUR_DELETE
DEALLOCATE CUR_DELETE

Mohit D Jethva

How do I know if localdb is running?

903

---

What is the difference between varchar and nvarchar?

904

---

How to manipulate data from one table to another table ?

918

---

What is bulkcopy in sql?

912

---

What are system databases into sql server (2005/2008)?

963

---

Is sql server difficult to learn?

871

---

How do you start single user mode in clustered installations?

908

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

6774

---

What is a cursor, index in sql?

1031

---

Name some of the open source software that you can use in alternative to SSR?

155

---

What are key constraints?

935

---

Why does sql studio use a single registered database repository? : sql server management studio

959

---

Define normalisation?

1068

---

Some queries related to SQL

941

---

What are the characteristics of modern DBMS?

1042

---