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,

---

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

---

Define tempdb database?

0 Answers  

---

How make remote connection in database?

1 Answers  

---

What is deploy, process and build? : sql server analysis services, ssas

0 Answers  

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---

How do SQL server 2000 and XML linked?

2 Answers  

---

What is difference between index and primary key?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

What is a natural primary key?

0 Answers  

---

What are different types of collation sensitivity?

0 Answers  

---

What is the difference between TRUNCATE and DROP?

0 Answers  

---