What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---

What is Lock table in SQL?

0 Answers   Wipro,

---

check, not null,unique

2 Answers   IBM,

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---

How do you read transaction logs

1 Answers  

---

What is the difference between createstatement and preparedstatement?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

How many columns can we include on clustered index ?

0 Answers  

---

What happens if null values are involved in comparison operations?

0 Answers  

---

What is default constraint in ms sql server?

0 Answers  

---

What are the differences between having and where clause.

0 Answers  

---