IN work like a OR in sql query but in is faster than OR in case of IN ser

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

Question Posted / navneet sharma

9 Answers
67264 Views
ASD Lab, CSC, Intelligroup, I also Faced
E-Mail Answers

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

Mention a few common trace flags used with sql server?

936

can an automatic recovery be initiated by a user? : Sql server administration

956

What is sql server database?

1016

Tell me what is sql profiler?

1035

How to use group functions in the select clause in ms sql server?

1058

What are the advantages of using a stored procedure?

1008

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1116

how can u get last observation in an unknown dataset ?

2436

What are the types of subquery?

1042

What is the openxml statement in sql server?

1077

What do you mean by sql server agent?

997

What are character string data types in ms sql server?

1259

What is a coalesce function?

1199

What is collation sensitivity?

1070

What is command parameter in ssrs?

164