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 do you understand by SQL*Net?
Tell me what is de-normalization and what are some of the examples of it?
What’s the use of custom fields in report?
what is difference between view and Dip.
What are the types of ssrs?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Do you know what is user defined datatypes and when you should go for them?
What is bcp? When does it use?
How would we use distinct statement? What is its use?
do views contain data ?
What is the name of the Database which IBM mainframe uses?
Explain primary key?
Tell me what is the significance of null value and why should we avoid permitting null values?
What do you mean by 'normalization'?
What is the simplest way to create a new database in ms sql server?