What is the difference between IN and EXISTS operators in
SQL Server?

Answer Posted / navneet sharma

IN work like a OR in sql query but in is faster than OR in
case of IN server will search whole table
EXISTS is use to find the required row and does not search
whole table

Is This Answer Correct ?    29 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are transactions in sql?

630


How can you control the amount of free space in your index pages?

688


What is the fillfactor concept in indexes?

620


How to execute stored procedure in select statement sql server?

613


What are the types of sql server?

600






Are resultset updatable?

597


What is report snapshot?

113


What is the purpose of floor function?

638


Explain system functions or built-in functions? What are different types of system functions?

655


What is wide table?

619


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

680


What is a database table?

609


What is a trigger and its types?

634


How you can get a list of all the table constraints in a database? : Sql server administration

594


What happens if strings are casted into wrong code pages in ms sql server?

693