Suppose that the table being queried holds different property values. The propertytype column represents the type of the property (an INT, a DATE, and so on), and the propertyval column holds the value in a character string. When propertytype is ‘INT’, the value in propertyval is convertible to INT; otherwise, not necessarily.
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Make sure not to assume that predicates are evaluated left to right. SQL Server could choose to evaluate the second predicate first and ignore the first predicate where the second predicate is false. This could impact the query result.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/57901/