How many types of Joins in SQL Server 2005?

Answer Posted / kalyana chakravarthy maddipati

Apart all the joins above there is one more join it is

NO EQUI JOIN ie emp.deptno!= dept.deptno or one can use <> sign instead

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is meant by replication of database?

531


What causes index fragmentation?

576


What are the advantages of using stored procedures?

538


What is the difference between the application object and session object?

597


What is "scheduled jobs" or "scheduled tasks"?

552






How to rename an existing column with sql server management studio?

496


What are the steps you can take to avoid “deadlocks”?

521


Explain system rowset functions?

554


How to convert character strings into numeric values?

573


What is the contrast amongst drop and truncate?

554


Name few of the dcl commands in sql?

550


How to insert multiple rows with one insert statement in ms sql server?

582


List out some of the requirements to set up a sql server failover cluster?

547


Do you know what is difference between index seek vs. Index scan?

517


How to receive returning result from a query?

584