Answer / Lajwant Singh

"In SQL Server, there are four main types of joins: INNER JOIN (returns only rows that have matching values in both tables), LEFT OUTER JOIN (returns all rows from the left table and matching rows from the right table), RIGHT OUTER JOIN (returns all rows from the right table and matching rows from the left table), and FULL OUTER JOIN (returns all rows when there is a match in either table)."

What is usually the first word in a sql query?

1 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

Why is replication required on the sql server?

1 Answers  

---

How do I clean up sql server transaction log?

1 Answers  

---

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

---

How to move database physical files in ms sql server?

1 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

Write an sql query to find first weekday of the month?

1 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

what is curser.

9 Answers  

---

Why use cursor in sql server?

1 Answers  

---

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---