Hello Team,

I was running the query select @@version command which is showing the correct output. But if I run the command like:

select 22version then it gives output 22.

so putting any number in place of "@@", it will show that number. I believe it should through some syntax error or some other error rather than giving the output. 

I have checked this in sql server 2005, 2008, 2008R2, 2012 and 2014.

Please let me know if i am wrong at any place.

Regards,

Ruchi Dubey

Hello,

pretty easy: SQL Server parse the Statement, detect 22 as numeric and threat the rest as column alias and this is because a qualifier can start with an underscore or a letter, but nut with a number:

select 22version 
select 22 AS version 

Hello,

pretty easy: SQL Server parse the Statement, detect 22 as numeric and threat the rest as column alias and this is because a qualifier can start with an underscore or a letter, but not with a number:

select 22version 
select 22 AS version 

Interesting! I would have thought it's a bug as we don't have a space here.