Answer / sravanthi

The Join keyword is used to query data from 2 or more
tables based on the relationship between the columns in the
table.

1. Join : Returns records when there is atleast one matched
record in both the tables.
2. Left Join : Returns all the records of the left table
irrespective match records in both the tables.
3. Right join : It is just reverse case of left join.
4. Full Join : Returns all the records from both the tables
irrespective matching.

Define full outer join in sql server joins?

0 Answers  

---

What is store procedure?

0 Answers  

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

what is difference between nchar and char in Sql server ?

3 Answers  

---

What do you need to connect php to sql server?

0 Answers  

---

How to create stored procedures with parameters in ms sql server?

0 Answers  

---

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

---

Explain in brief how sql server enhances scalability of the database system?

0 Answers  

---

Explain what is meant by replication of database?

0 Answers   Cap Gemini,

---

What is role playing dimension with two examples? : sql server analysis services, ssas

0 Answers  

---

How can we remove orphan records from a table?

0 Answers  

---

1 01 101 01010

0 Answers  

---