Is natural join and equi join same?

0 Answers  

---

How do you run a trace?

0 Answers  

---

What is a document index?

0 Answers  

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

How to test odbc dsn connection settings?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

syntax for deleting the database in T SQL

5 Answers  

---

Which Model uses the SET concept

0 Answers   Infosys,

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

How to create a large table with random data for index testing in ms sql server?

0 Answers  

---