Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and EXISTS operators in
SQL Server?
- 9 Answers
- 66813 Views
- ASD Lab, CSC, Intelligroup, I also Faced
- E-Mail Answers
Answer Posted / vijaykumar dolli
using the IN clause, you're telling the rule-based
optimizer that you want the inner query to drive the outer
query (think: IN = inside to outside).
When you write EXISTS in a where clause, you're telling the
optimizer that you want the outer query to be run first,
using each value to fetch a value from the inner query
(think: EXISTS = outside to inside).
Thank you
| Is This Answer Correct ? | 106 Yes | 15 No |
Post New Answer View All Answers
What is shared lock?
What are wait types?
Do you know what is fill factor and pad index?
how to determine the service pack currently installed on sql server? : Sql server database administration
Explain how you can deploy an SSRS report?
What is update_statistics command?
What is a result set object returned by odbc_exec()?
What is conditional split?
What are the methods used to protect against sql injection attack?
How to check status of stored procedure in sql server?
What are differences in between sql server 2012 and sql server 2016?
What is the default value of an integer data type in sql server 2005?
What is a livelock?
What is use of @@ spid in sql server?
What is checkpoint in sql server?
