The example expression highlighted in green above (A <> 0 AND B / A > 1) is said to evaluate differently in SQL 2000 and SQL 2005, but I don’t see any ungrouped use of the unary + or – that would affect their evaluation.
Did I miss something in this example?
Nope.. I missed something. Greg’s original message referenced the operator precendence list for SSIS, and I found the list for SQL Server. Believe it or not, they’re different.
Here’s a link to the SSIS 2005 Operator Precedence list, and here’s a pointer to a forum thread discussing a change in some of this documentation. I’m still looking for the list for DTS in SQL Server 2000.
More as I learn it.. either via research or the kindness of others..