Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of Joins in SQL Server 2005?
- 9 Answers
- 12009 Views
- CarrizalSoft Technologies, HCL, I also Faced
- E-Mail Answers
Answer Posted / abi
Types of Joins
1.Inner Join
2.Outer Join
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
3.Self Join
4.Cross Join
5.Equi-Join
6.Cross Apply Join
7.Outer Apply Join
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Why use view instead of a table?
Your table has a large character field there are queries that use this field in their search clause what should you do?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is a functions and types in sql server?
How to create function with parameter in sql server?
What are the properties of the transaction?
Can a synonym name of a table be used instead of a table name in a select statement?
What is the optimization being performed in oracle and SQL Server?
which table keeps the locking information? : Sql server administration
How to create median function?
What is the name of reporting services config file and what’s it’s used for?
What is the difference between function and stored procedure in sql server?
Explain in details security in SQL azure?
What are the types of indexing?
