What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....
Answer Posted / piyush bajaj
I have posted a sequel article relating to this topic at:
SQL Server - How to Merge Data with JOINS? – PART 1
http://www.sqlservergeeks.com/articles/sql-server-bi/35/sql-server-how-to-merge-data-with-joins-%E2%80%93-part-1#78
SQL Server - How to Merge Data with JOINS? – PART 2
http://www.sqlservergeeks.com/articles/sql-server-bi/36/sql-server-how-to-merge-data-with-joins-%E2%80%93-part-2
SQL Server - How to Merge Data with JOINS? – PART 3
http://www.sqlservergeeks.com/articles/sql-server-bi/37/sql-server-how-to-merge-data-with-joins-%E2%80%93-part-3
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between composite index and covering index?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Explain features and concepts of analysis services?
Do you know what is user defined datatypes and when you should go for them?
What is clr ddl trigger?
What is trigger and different types of Triggers?
Explain different forms of normalization?
Do you know what is difference between index seek vs. Index scan?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
How to create a user to access a database in ms sql server using "create user" statements?
What command is used to create a database in the sql server and how?
How to create an index on a view?
Tell me what are the advantages of using stored procedures?
what kind of lan types do you know? : Sql server database administration
What does REVERT do in SQL Server 2005?