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.

Which database stores information about replication?

0 Answers  

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

When I run the sql server 2000 setup, it just hangs. What do I do?

0 Answers  

---

What are sql servers used for?

0 Answers  

---

What are security principals used in sql server 2005?

0 Answers  

---

How we can refresh the view?

0 Answers  

---

How can I create a new template for import ? : sql server management studio

0 Answers  

---

Explain different types of locks in sql server.

0 Answers  

---

how to rest identity columns in sql server

3 Answers   Matrix,

---

What is the system function to get the current user's user id?

3 Answers   TCS,

---

What is 2nf in normalization?

0 Answers  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---