Carlo Romagnano (5/28/2010)
Try this:select*from sysobjects order by 1desc
No space in 1desc
I've seen that too before, same like this:
declare @a int set @a=1select @a
However, select1 or select@a won't work. It seems that a keyword preceded by an integer always works. I would definitely avoid using it though, it only confuses me.
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2