Post reply

SQL syntax

  • June 11, 2007 at 2:54 am

    #174072

    Hi all

    This could be a good question for QOD

    What does the following sql do

    SELECT

    1e

    SELECT

    2s

    SELECT

    3b

    SELECT

    4v

     

    I accidently typed in a char after a value and it did not return a syntax error is it somekind of formatting. The first statement return with no column name and the rest with the following char

  • June 11, 2007 at 4:30 am

    #711940

    SQL Server supports Float data type values ranging from -1.79E + 308 through 1.79E + 308 & Real allows Floating precision number data from 3.40E + 38 through 3.40E + 38. So SELECT 1e is float value which is equivalent to 1.0. Similarly SELECT 1e+1 = 10.0 and so on...

    In SELECT 2s, SELECT 3b, SELECT 4v queries s,b,v are column aliases.  

     

      

    Regards
    Shrikant Kulkarni

  • June 11, 2007 at 4:52 am

    #711946

    Thanks for the reply Shrikant. I learnt something 2day. Keep well

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply