Answer Posted / 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 generate create function script on an existing function?

1049

---

How to select some specific rows from a table in ms sql server?

963

---

What is lock escalation? : sql server database administration

1103

---

What is nonclustered index with included columns ?

909

---

What is a View ? Can we insert, Update and delete a view?

942

---

What is for xml in sql server?

979

---

What is difference statement and preparedstatement?

936

---

Does order by actually change the order of the data in the tables or does it just change the output?

1084

---

What is database dimension? : sql server analysis services, ssas

1035

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

931

---

what is the difference between a primary key and a unique key? : Sql server database administration

948

---

When would you use it?

945

---

What are the different authentication modes in sql server? How can it be changed?

1026

---

How do I open port 1433?

883

---

what's the difference between delete table and truncate table commands? : Sql server database administration

923

---