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.

What is GUID in sql server?

1216

---

What are the differences between having and where clause.

1012

---

What is the difference between having clause and where clause in sql server?

1162

---

how to do partition in sqlserver

2539

---

What is the advantage of sql server?

1078

---

What is acid properties?

1188

---

Do you know what are the steps to process a single select statement?

1016

---

Differentiate between sql temp table vs table variable?

923

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1002

---

What are key constraints?

1014

---

What is the default server name for sql server?

1228

---

What is the standby server?

998

---

What are functions in the sql server?

1288

---

How to list all dsn entries on your local machine using odbc_data_source()?

1089

---

What is tempdb in sql server?

1023

---