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 do you mean by acid?
What is a covering index?
What is difference between foreign key and unique key?
What are scalar functions?
What is tablesample?
What are subqueries in sql server? Explain its properties.
What is resultset concur_updatable?
What is the fastest way to permanently delete a 1 million row table named customers?
Why I am getting this error when renaming a database in ms sql server?
List few advantages of stored procedure.
What are commonly used odbc functions in php?
What is 2nf normalization?
How can I add Reporting Services reports to my application?
How can we solve concurrency problems?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration