How many types of Joins in SQL Server 2005?
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
What is 1nf 2nf?
What is the architecture of ms sql reporting service?
Why are you getting errors when creating a new odbc dsn?
What is the function of inner join?
 Explain what is sql override for a source taLle in a mapping?
What part does database design plays a role in performance of an sql server-based application?
What is sql injection? How to protect against sql injection attack?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are the grouping functions?
List out different types of normalizations in sql server and explain each of them?
What happens if you are trying to access a schema not owned by you?
Explain about SQLOS?
How do I save a stored procedure in sql server?
What is the datatype of rowid?
How to disable a login name in ms sql server?