How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

What are the different ways you can create databases in sql server?

0 Answers  

---

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

How we can compare two database data?

0 Answers  

---

how to get 25th row in any table in sqlserver can u tell me syntax

8 Answers  

---

What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  

---

How to configure and test odbc dsn settings?

0 Answers  

---

What is for xml in sql server?

0 Answers  

---

Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,

---

What is the Main Difference between ACCESS and SQL SERVER?

0 Answers   MindCracker,

---

How create table structure only from tableA to TableB if TableA have some data?

4 Answers  

---