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
Do you know hot add cpu in sql server 2008?
What is filter index?
What are the types of lock supported by ?
What method is used by the Command classes to execute SQL statements that return single values?
What is importing utility?
What are four major operators that can be used to combine conditions on a where clause?
Do you know how to implement service broker?
Can two different columns be merged into single column? Show practically?
Which rendering formats are affected by the pagesize properties?
How to enable/disable indexes?
How do I find the size of a sql server database?
How to create percentile function?
Which are ddl commands?
What is @@rowcount in sql?
What stored by the master? : sql server database administration