Answer / Balwant Singh

Right Outer Join in SQL Server Joins returns all records from the right table and matched records from the left table. For unmatched records on the left, it returns nulls. The syntax for a Right Outer Join includes the RIGHT OUTER JOIN keyword followed by the two tables to be joined.

What is the difference between sdf and mdf?

1 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

Explain the properties of a relational table?

1 Answers  

---

Is it possible in sql table to have more than one foreign key?

1 Answers  

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1 Answers  

---

What is dirty page?

1 Answers  

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1 Answers  

---

What is the difference between stored procedure and user defined functions?

1 Answers  

---

Why it is recommended to avoid referencing a floating point column in the where clause?

1 Answers  

---

Tell me what is log shipping?

1 Answers  

---

Does windows server 2016 come with sql server?

1 Answers  

---

What is postgresql server?

1 Answers  

---