Home Forums Article Discussions Article Discussions by Author Discuss content posted by jrtupa SELECT (Transact-SQL) RE: SELECT (Transact-SQL)

  • October 29, 2012 at 6:39 am

    #1553700

    kapil_kk (10/25/2012)

    One question, I am confused on this...

    select ID, name name from person

    select ID ID, name name from person

    Both these statements dont give any error message and run successfully...

    wht is it so?

    Hi kapil,

    1st statement :-

    it's showing that you are giving the alias column name to column 2(name). I can also right this like:-

    select ID, name as [name] from person

    or

    select ID, name as [Column_2] from person

    2nd Statement :-same thing happen in 2nd statement.

    Check below statement. have fun

    select '--------------------' as TT

    select 233 as '____________'

    Thanks

    Vinay

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!