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.

Explain sql server service broker?

1 Answers  

---

What is a document index?

1 Answers  

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1 Answers   MCN Solutions,

---

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

---

Explain boyce and codd normal form(bcnf)?

1 Answers  

---

How to concatenate two character strings together?

1 Answers  

---

What are acid properties of transaction?

1 Answers  

---

select empid empname from employee What is the result for the about query?

4 Answers  

---

What is a coalesce function?

0 Answers  

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1 Answers  

---

What is the purpose of update statistics and scope_identity() function?

1 Answers  

---

What are sql dirty pages?

1 Answers  

---