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

Which table keeps the locking information?

931

---

How to loop through the result set with @@fetch_status?

1351

---

Explain aggregate functions?

1086

---

How to insert multiple rows with a subquery?

1140

---

What happens if time-only values are provided as date and time literals?

1019

---

What are audit control procedures?

993

---

What is unpivot?

1013

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

949

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1080

---

Do you know what is difference between index seek vs. Index scan?

956

---

Differentiate between mongodb vs. Sql server?

1101

---

What is read committed?

1095

---

How can I change procedure name in sql server?

1052

---

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

1016

---

Do you know what guidelines should be followed to help minimize deadlocks?

970

---