Answer / Ashish Kushwaha

In SQL, joins are used to combine rows from two or more tables based on a common column (key) between them. There are several types of joins:
1. INNER JOIN - Returns only the matching rows from both tables.
2. OUTER JOIN (LEFT JOIN/RIGHT JOIN) - Includes all the rows from one table and the matched rows from another table.
3. FULL OUTER JOIN - Returns all the rows when there is a match in either left or right table.
4. CARTESIAN JOIN (CROSS JOIN) - Joins every row of two tables without any conditions.

Detail about query optimizer?

1 Answers  

---

What structure can you implement for the database to speed up table reads?

1 Answers  

---

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers  

---

What is difference between line feed ( ) and carriage return ( )?

1 Answers  

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

What is left outer join in sql server joins?

1 Answers  

---

What xml support does the sql server extend?

1 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

What is data compression?

1 Answers  

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

Why I am getting this error when dropping a database in ms sql server?

1 Answers  

---

What do you mean by stored techniques? How would we use it?

1 Answers  

---