SQLBPA and order by constant

Have you tried Sql Best Practices Analyzer ? Very good and useful tool as far as I can see during the first sessions. One of the features is "Yukon readiness" - whether your database is ready to move to Yukon. One thing frightened me though. It is "statements using ORDER BY clause with constants.". I was wondered if Yukon understands the following:

select col1,col2
from mytable
order by 1

Christian Kleinerman clarifies:

"The example you give will continue to be valid. The order by with integer constants is valid syntax as per the SQL 99 ANSI standard. The rule is "order by non-integer constants". For example:

select col1,col2
from mytable
order by 'a'

or for example:

select col1,col2
from mytable
order by NULL

You may argue this is useless syntax. We kind of agree; that's why it is changing in SQL Server 2005."

Don't forget to watch SQLBPA on MSDN TV.

Related Posts:

• T-SQL Paging Series. RowCount
• Check Constraint vs. Rule
• Rendering depends on HTML source formatting
• sp_sproc_columns and Profiler
• SQL Function for Date Sequences (Version 2.1)
• MSSQL: Some Undocumented Features
• Generate Calendar Dates. Version 2.0
• My howto on sqljunkies
• How to PIVOT Tables in MSSQL 2000
• QA vs VS2003. Debugging stored procedure.