Answer Posted / sanjay kumar dinda

Deletion of Rows depends upon the different condition...
Consider based on n columns the entire recordset is
treating a duplicate... We can delete the duplicate by
using following method...

Add one column and set uniue values to that column..

ALTER TABLE TABLE1 ADD ID INT IDENTITY(1,1)

COnsider T contains 40 columns and based on C1,C2,C3 we
have to find the duplicate and we have to delete the same...


Delete T1

FROM TABLE1 T1,TABLE1 T2
WHETE T1.C1=T2.C1 AND
T1.C2=T2.C2 AND
T1.C3=T2.C2
AND T1.ID>T2.ID


I think this will help....

Describe in brief authentication modes in sql server.

1034

---

Create and insert into temp table in sql server?

1037

---

What are types of storage modes? : sql server analysis services, ssas

1047

---

What is precedence constraint?

990

---

Which joins are sql server default?

1014

---

What are the essential components of sql server service broker?

1020

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1267

---

What is user-defined multi-statement table-valued function?

1072

---

What is normalization of database?

1110

---

What is the cartesian product of table?

1016

---

How do I find query history in sql server?

948

---

Which language is supported by sql server?

1019

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1169

---

Explain important index characteristics?

1042

---

Explain the stored procedure?

1057

---