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."
Wednesday, June 16, 2004 1:58 AM