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

What is index, cluster index and nonclustered index?

1048

---

What is read committed?

1175

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1064

---

where the connection string store in the database

2124

---

What are the differences between having and where clause.

1023

---

How adventureworkslt tables are related?

984

---

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

1130

---

Can group by and orderby be used together?

1069

---

How to insert and update data into a table with "insert" and "update" statements?

1046

---

What is a View ? Can we insert, Update and delete a view?

1064

---

Explain about system database?

1110

---

What command do we use to rename a db, a table and a column?

982

---

What is in place upgrade in sql server?

1095

---

Do you know what are pages and extents? : SQL Server Architecture

1040

---

Write down the syntax and an example for create, rename and delete index?

1027

---