comparing a NULL to anything yields unknown.
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
If concerned about the order in which a predicate will be evaluated, make sure that the intended precedence order is not broken through a short-circuit by allowing for UNKNOWN like TRY_CAST.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/57906/