Answer / Jaswant Kumar

In SQL, a Join operation combines rows from two or more tables based on a related column between them. There are several types of joins such as INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

What is the standby server?

1 Answers  

---

What is optimistic concurrency?

1 Answers  

---

Differentiate between a having clause and a where clause.

1 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

What is difference between Triggers and store procedure?

2 Answers  

---

Different Types of Functions ?

2 Answers   Satyam,

---

Why we use trigger in sql server with example?

1 Answers  

---

What is an inner join?

1 Answers  

---

What are the security related catalog views? : sql server security

1 Answers  

---

What is best institute to Learn DotNET And SQL in chennai?

1 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---

Explain what is cte (common table expression)?

1 Answers  

---