Database Programming: Operator Precedence In SSIS

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


Comments (3)

  1. Anonymous says:

    This post will (hopefully) close a thread which runs here and here . When we last addressed this issue,

  2. alex says:

    Programming required a lots of experience and knowledge Database Programming: Operator Precedence In SQL Server database programming as well, you can get more information about programming from this,