What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....

Answer Posted / wiki man

http://en.wikipedia.org/wiki/Join_(SQL)

Is This Answer Correct ?    17 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between delete table and truncate table commands? : Sql server database administration

515


What are the difference between clustered and a non-clustered index?

580


What is factless fact table? : sql server analysis services, ssas

551


What are the types of containers in ssis?

594


What is use of except clause? How it differs from not in clause?

591






Explain what is lock escalation?

565


Explain transaction server implicit?

513


What are the differences between DDL, DML and DCL in SQL?

750


What does indexation mean?

520


Why the trigger fires multiple times in single login?

715


What are system databases into sql server (2005/2008)?

574


Can we insert data into view sql server?

506


What is the server name in sql server?

549


Define normalisation?

666


What is a field name?

506