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..
-wp
Comments
Anonymous
January 01, 2003
PingBack from http://blogs.technet.com/wardpond/archive/2008/05/06/database-programming-operator-precedence-in-sql-server.aspxAnonymous
January 01, 2003
This post will (hopefully) close a thread which runs here and here . When we last addressed this issue,Anonymous
January 12, 2009
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, http://www.cyberdesignz.com/