Answer Posted / sumit

I have The Same Problem And I Have Done Woth This


DECLARE @empid int, @empname varchar(50),@Cnt int

DECLARE duplicate_cursor CURSOR FOR

-- select all columns in table bit you must have an count column
select empid,empname, count(*) Cnt
from tbl_Temp
group by empid, empname
Having count(*) > 1

OPEN duplicate_cursor

FETCH NEXT FROM duplicate_cursor
INTO @empid, @empname,@Cnt

WHILE @@FETCH_STATUS = 0
BEGIN

SET @Cnt = @Cnt - 1

SET ROWCOUNT @Cnt

DELETE tbl_Temp
WHERE @empid = empid AND @empname = empname


FETCH NEXT FROM duplicate_cursor
INTO @empid, @empname
END

CLOSE duplicate_cursor
DEALLOCATE duplicate_cursor

-- dont forget to set rowcount to 0
SET ROWCOUNT 0

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1113

---

What is a DBMS, query, SQL?

992

---

Where are full-text indexes stored?

944

---

What does <> symbol mean?

918

---

What are acid properties of transaction?

889

---

What is the use of sql profiler in sql server 2012?

839

---

Tell me the phases a transaction has to undergo?

917

---

What are the steps you must follow to hide sql server instances?

928

---

Define msdb database?

970

---

please differentiate between delete and truncate?

938

---

What is the datatype of rowid?

875

---

How to access the deleted record of an event?

972

---

How can we migrate from SQL server to SQL Azure?

113

---

What is difference between createstatement and preparedstatement?

1020

---

How to choose all records from the table?

997

---