Answer Posted / vijay

The SQL join command is used to join two or more tables. At
times you may need to join two or more tables to retrieve
the information you need from your SQL database

Types Of Joins-
1.Inner Join
2.Outer Join -types -
left Outer,
Right Outer,
Full Join

3.Cross Join
4.Self Join

What is transaction server explicit transaction?

969

---

Explain the difference between control flow and data flow?

932

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

980

---

Which is the main third-party tool used in sql server?

882

---

what are the different ways to return the rowcount of a table?

942

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

924

---

What is the purpose of self join?

914

---

What is difference between equi join and natural join?

963

---

What is difference between views and tables?

913

---

Explain temporary table vs table variable by using cursor alternative?

942

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1055

---

What is system stored procedures?

977

---

What is indexing a document?

967

---

System requirements for sql server 2005 express edition?

951

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

941

---