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
What are transactions in sql?
How can you control the amount of free space in your index pages?
What is the fillfactor concept in indexes?
How to execute stored procedure in select statement sql server?
What are the types of sql server?
Are resultset updatable?
What is report snapshot?
What is the purpose of floor function?
Explain system functions or built-in functions? What are different types of system functions?
What is wide table?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is a database table?
What is a trigger and its types?
How you can get a list of all the table constraints in a database? : Sql server administration
What happens if strings are casted into wrong code pages in ms sql server?