Ward Pond's SQL Server blog

Ruminating on issues pertinent to the design and development of sound databases and processes under Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000 (while reserving the right to vent about anything else that's on my mind)

Database Programming: Operator Precedence In SSIS

Database Programming: Operator Precedence In SSIS

  • Comments 3
  • Likes

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


Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment