Interested to Buy Any Domain ? << Click Here >> for more details...
What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....
- 9 Answers
- 63771 Views
- DELL, i Tech, Infosys, Siemens, TCS, I also Faced
- E-Mail Answers
Answer Posted / prangya mishra
joins are used for retreiving the information from multiple
tables at a time & presenting it.
we have 5 different types of joins
1.Equi join
2.Non-Equi join
3.Self join
4.Cartesian join
5.outer join
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
What are sql server functions?
What are different types of statement?
Explain comment on transactions?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
How to replace given values with null using nullif()?
What is compound operators?
What are different types of schemas?
What is the sql server 2000 version number?
Can you explain about buffer cash and log cache in sql server?
Suggest a method of joining two tables.
Can a unique index be created on a column, which contains null?
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?
Can we store videos inside the sql server table?
What is spid in sql server profiler?
What do you mean by an execution plan? How would you view it?
