Answer / Danish Ali

SQL Server supports four default join types: INNER JOIN (to return only matching records from both tables), LEFT OUTER JOIN (to return all records from the left table and matching records from the right table, with nulls for non-matching values on the right side), RIGHT OUTER JOIN (similar to LEFT OUTER JOIN but swaps the role of the two tables), and FULL OUTER JOIN (returns all records when there is a match in either table, with nulls for non-matching values).

How do I run sql server 2014?

1 Answers  

---

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  

---

Explain couple pf features of SQL server

2 Answers  

---

What is a select query statement in ms sql server?

1 Answers  

---

How to count groups returned with the group by clause in ms sql server?

1 Answers  

---

Can multiple columns be used in sql group by clause in ms sql server?

1 Answers  

---

What are different types of database indexes?

1 Answers  

---

How do I start sql server 2017?

0 Answers  

---

 Explain what is sql override for a source taLle in a mapping?

1 Answers   Informatica,

---

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

---

How to Run a Query on a Remote SQL Server?

2 Answers  

---

What is normalization of database? What are its benefits?

1 Answers  

---