Which query will give an error?

  • Vimal Lohani

    SSCommitted

    Points: 1650

    Comments posted to this topic are about the item Which query will give an error?

    Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

  • twin.devil

    SSC-Insane

    Points: 22208

    Good Knowledge base question. Thanks for sharing 🙂

  • This was removed by the editor as SPAM

  • Ed Wagner

    SSC Guru

    Points: 286957

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Thank you for the post, Vimal, good one.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • LearnModeOn

    SSC Enthusiast

    Points: 154

    i guessed correctly

    select this!!

  • sestell1

    SSChampion

    Points: 10230

    XML... yuck. :sick: :laugh:

  • SQLRNNR

    SSC Guru

    Points: 281210

    sestell1 (8/15/2014)


    XML... yuck. :sick: :laugh:

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    SQLRNNR (8/15/2014)


    sestell1 (8/15/2014)


    XML... yuck. :sick: :laugh:

    +1

    hmmm... interesting...

    I know the feeling of "yuck"... but never used with "xml"... so out of curiosity anybody care to shed some light by providing in-depth details? 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Revenant

    SSC-Forever

    Points: 42467

    I have to produce XML quite often whether I like it or not.

    Thanks, Vimal!

  • TomThomson

    SSC Guru

    Points: 104762

    Nice straightforward question (although the subject matter - XML - is not nice).

    By choice use I never use XML, so it's only the odd QotD that keeps me from forgetting everything about it.

    Tom

  • Hany Helmy

    SSChampion

    Points: 13321

    sestell1 (8/15/2014)


    XML... yuck. :sick: :laugh:

    Definitly yuck 🙂

  • Eirikur Eiriksson

    SSC Guru

    Points: 182344

    Thank you for the timely question Vimal, XML is a topic that definitely needs more coverage, especially when the current SQL Server's capabilities provide some of the best tools for the job;-)

    😎

  • Hany Helmy

    SSChampion

    Points: 13321

    Had to try this as I have no hands-on experience on XML part in SQL Server.

    This question reminds me of the 70-461 exam questions 🙂

  • Eirikur Eiriksson

    SSC Guru

    Points: 182344

    Hany Helmy (8/17/2014)


    Had to try this as I have no hands-on experience on XML part in SQL Server.

    This question reminds me of the 70-461 exam questions 🙂

    We all have to start somewhere:-)

    Must admit that few of the comments remind me of the early years of mobile phones, "who will ever need one?"

    😎

Viewing 15 posts - 1 through 15 (of 25 total)

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