Database Programming: Operator Precedence In SSIS

  • Article

This morning's post on Operator Precedence was a little misleading, as Scott pointed out in his comment:

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..

     -wp