Answer Posted / mohamed ibrahim

Deleting multiple duplicate rows in a table
Ex . I have the Table named as TestMaster
to delete duplicate rows from the testmaster using Cursor &
RANK() Function.
for ex.the table having the fields ID,Name
the having the following data
oupput:
ID NAME
1 Raja
1 Raja
1 Raja
2 Mohamed
2 Mohamed
2 Mohamed

To Delete duplicate Rows in table to follow the below code:

DECLARE @ID INT
DECLARE delduplicaterecords_Cursor CURSOR
FOR SELECT ID FROM TempMaster
OPEN delduplicaterecords_Cursor
FETCH NEXT FROM delduplicaterecords_Cursor INTO @ID

WHILE @@FETCH_STATUS = 0
BEGIN
WITH CTE
AS
(SELECT
ROW_NUMBER () OVER (ORDER BY ID) AS RowID,
*
FROM TempMaster WHERE ID=@ID )

DELETE FROM CTE WHERE RowID <> 1

FETCH NEXT FROM delduplicaterecords_Cursor INTO @ID
END

CLOSE delduplicaterecords_Cursor
DEALLOCATE delduplicaterecords_Cursor

Explain optimistic and pessimistic concurrency?

974

---

What is the difference between clustered and a non-clustered index?

1010

---

How to enter date and time literals in ms sql server?

992

---

Explain user defined functions?

975

---

How do I port a number to sql server?

1021

---

Name few endpoints exposed by ssrs 2012?

355

---

What are the main sources of data?

1076

---

Can we store videos inside the sql server table?

946

---

What is sql injection and why is it a problem? : sql server security

1113

---

What is a print index?

866

---

How can a user-defined datatype be created?

974

---

What are the advantages of having an index on the sql server?

912

---

What are the different types of triggers in SQL SERVER?

1108

---

How to find table changes in sql server?

1096

---

How to change a login name in ms sql server?

1064

---