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
How to rename an existing column with sql server management studio?
What authentication modes does sql server support?
How to write a query with a right outer join in ms sql server?
what happens on checkpoint? : Sql server database administration
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
How to remove duplicate rows from table except one?
What is hot add cpu in sql server 2008?
How is sql server used?
Explain throw statement in sql server 2008?
Explain what is the difference between union and union all?
How can a user-defined datatype be created?
What are number line correlation administrators will use while working with a subquery?
what is the information that can be stored inside a bit column? : Sql server database administration
What are the difference between “where” and “having” clause in sql server?
How many types of the database links?