SELECT (Transact-SQL)

  • palotaiarpad

    SSCarpal Tunnel

    Points: 4889

    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...

    thanks

    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

    SSChampion

    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)

    SSCrazy

    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

    SSC-Insane

    Points: 23096

    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: 442144

    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

    SSC-Addicted

    Points: 465

    D'oh! Hit the wrong option...

  • Ken Wymore

    SSCoach

    Points: 16391

    nice easy one for a Friday. Thanks!

  • Kick6Tiger

    SSCrazy

    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

    SSC-Forever

    Points: 42467

    Easy one... Thanks!

  • Danny Ocean

    SSCertifiable

    Points: 6098

    opps, i have selected wrong answer in hurry.

    Thanks
    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