SELECT (Transact-SQL)

  • palotaiarpad

    SSCarpal Tunnel

    Points: 4893

    An easy basic question! Thanks!

  • This was removed by the editor as SPAM

  • JoseACJr

    SSC Eights!

    Points: 932

    Lokesh Vij (10/25/2012)

    demonfox (10/25/2012)

    I found the glitch ..

    nice question...


    A trick to catch the glitch.

    1) Use SSMS, go to "Query" and select "IntelliSense Enabled"

    2) Copy paste the code

    3) the syntax error in the query (with error) will be highlighted with zig-zag red line πŸ™‚

    Check the attached image.

    Thanks to all!

    Ps: donΒ΄t "copy paste the code", ok ?


  • Thomas Abraham


    Points: 10761

    Thanks for the question. A basic but clear one. Just right for a Friday. More?

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • (Bob Brown)


    Points: 2705

    Thanks. I needed an easy one for Friday. Confused me for a second with having 5 possible answers and showing only 4 examples but was awake enough to get it right.

  • Dan Graveen

    Mr or Mrs. 500

    Points: 525

    I learned something new today. I've always used the "=" or "AS" when doing column aliases. So when I looked through the choices on this question, "select Id, name name from Person" seemed like the obvious answer, but fortunately I still looked at the remaining choices, and the last one, while easy to overlook if you skimmed the questions would not work as the column source is always on the right side of the equals.

    I've been so used to using the AS or "=" I never thought you could omit them. πŸ™‚

  • mtassin


    Points: 23099

    Thanks, I needed an easy Friday question... the coffee machines are out of order today.

    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • Lynn Pettis

    SSC Guru

    Points: 442312

    An easy, back to basics question.

  • Paul White

    SSC Guru

    Points: 150442

    If Microsoft ever decide to replace the T-SQL parser with a human, they won't choose me.

  • dawargo


    Points: 465

    D'oh! Hit the wrong option...

  • Ken Wymore


    Points: 16572

    nice easy one for a Friday. Thanks!

  • Kick6Tiger


    Points: 2368

    After I pulled the pencil from my eye and reformatted the question...easy to spot. :w00t:

    Aigle de Guerre!

  • swarn_soft

    Old Hand

    Points: 351

    nice and easy question to check the basics

  • Revenant


    Points: 42467

    Easy one... Thanks!

  • Vinay Kumar


    Points: 6098

    opps, i have selected wrong answer in hurry.

    Vinay Kumar
    Keep Learning - Keep Growing !!!

Viewing 15 posts - 16 through 30 (of 34 total)

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