Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ms65g
Constraint Violating Yak Guru
497 Posts |
 Posted - 2009-07-30 : 04:40:32
|
| Is "= ANY" or "= SOME" equal with "IN"?It seems "= ANY" is faster than "IN"!test_expression [ NOT ] IN ( subquery | expression [ ,...n ] ) scalar_expression { = | < > | ! = | > | > = | ! > | < | < = | ! < } { SOME | ANY } ( subquery ) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-30 : 14:29:41
|
| nope.they are not equal=some,=any gives boolean result while in looks for values |
 |
|
|
|
|
|
What is difference between "=ANY" and "IN"?