How many types of Joins in SQL Server 2005?

Answer Posted / g.ramesh

Inner Join
Outer Join
Crros Join

Is This Answer Correct ?    6 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the native system stored procedure to execute a command against all databases?

526


What is the importance of concurrency control?

652


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

548


What is an identity?

559


What is filter index?

507






what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

490


What is difference between Datepart() and Datename() in SqlServer?

709


How to create new tables with "create table" statements in ms sql server?

559


What are trace flags?

583


Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

582


What are the advantages of policy management?

575


Define self join in sql server joins?

510


What is query processing?

533


what is difference between view and Dip.

1987


Explain alternate key, candidate key and composite key in sql server?

513