it is not necessarily going to evaluate the expressions in left-to-right order. It could decide, based on cost-related reasons, to start with the second expression, and then if the second expression evaluates to true, to evaluate the first expression as well.
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
You can't assume that SQL server will evaluate expressions left to right. It makes a determination based on system resources.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/18767/