ssismaddy (9/23/2009)
It might be the silly question....but, why we are not able to display e ??select 1.a -- gives the column name a and prints 1 , which is fine.
select 1.e -- gives no column name !!!!!!!!!
howz this?
1.e is probably the same as 1.0e0, which is scientific notation. So, the "e" is part of the number, just like the decimal point, and is not interpreted as a column alias. That's my guess.