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.

How to create database with physical files specified in ms sql server?

0 Answers  

---

What are statistics?

0 Answers  

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

How do you delete a data source?

0 Answers  

---

Differentiate between mongodb vs. Sql server?

0 Answers  

---

---

How do I list the available tables in a database I'm querying?

4 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

what is difference between nchar and char in Sql server ?

3 Answers  

---

What is transaction server distributed transaction?

0 Answers  

---

What is the recursive stored procedure in sql server?

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---