How many types of Joins in SQL Server 2005?
Answer Posted / vishal
1. Inner Join
2. Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
3. Cross Join
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
how we use window authentication connection with sql server.?
What is the main purpose of having conversation group?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What are the system database in sql server 2008?
What is indexed view? How to create it?
What is the difference between composite index and covering index?
whats new about truncate in sql server 2008?
How to create a view on an existing table in ms sql server?
What is identity?
What is the name of reporting services config file and what’s it’s used for?
How many types of attribute relationships are there? : sql server analysis services, ssas
Can we delete data from a view?
Write SQL queries on Self Join and Inner Join.
When to use Inner join & when to use subquery?
What are different types of views?