Unique constraints

  • arun.sas

    SSChampion

    Points: 11831

    Comments posted to this topic are about the item Unique constraints

  • Andrius-794186

    SSC Veteran

    Points: 225

    There is a little mistake: you don't need tags <strong> and </strong> in question.

  • BrainDonor

    SSCoach

    Points: 19191

    The 'strong' tags means that there is an error, which needs correcting before it will run. Then when it runs it gives the warning, so it either has two answers or it is incorrect to say it gives a warning and completes when it actually gives a syntax error first.

    Steve Hall
    Linkedin
    Blog Site

  • ChiragNS

    One Orange Chip

    Points: 26137

    tags almost made me choose the wrong option.

    "Keep Trying"

  • Kevin Gill

    SSCrazy

    Points: 2240

    Tags DID make me choose the wrong option. I assumed it was asking about some subtlety of how sqlserver deals with unexpected xml elements. As such, I too reckon I was actually right to say it needs correction :o)

    -------------------------------
    Oh no!

  • Joe Kelly-8908

    SSC-Addicted

    Points: 445

    The query must be corrected before it can run. The < symbol is interpreted as LT, not as XML, so the query will not compile.

    A badly needed point denied us ... ;-((


    Tks,

    JK

  • sjimmo

    SSChampion

    Points: 11139

    The question was about running the code. The code will not run the way it is written. Afte getting it wrong, I tried the code and received an error. Thus, the code needs modification to run. If you are planning to post more questions, please try it before submitting it. The point should be given to all who answered that the code had to be modified.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • Lee Nadelman

    SSCertifiable

    Points: 5320

    The tags are not valid SQL Server syntax. The correct answer should be Statement needs some correction for compile.

  • vinod-385211

    SSC Rookie

    Points: 34

    I am agrry with sjimmo..

  • Brian LeBlanc-449582

    SSChasing Mays

    Points: 609

    --- Incorrect syntax near '<'. ----- They got it wrong.

    Brian RL: Be serious about your work, but do not take yourself too seriously {Philip A. Fisher}

  • edwisdahl

    SSC Enthusiast

    Points: 181

    Agreed. Put needs some correction before running because of strong tags... got it wrong, so I tried it on local server. It DOES need correction before running...

  • Adrian Aucoin Jr.

    SSC Veteran

    Points: 293

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near '<'.

    Agree with others, i'm so used to taking things verbatim that i kinda wondered if it was a trick question, either way my "needs correction" answer was wrong :angry:

  • Tom Garth

    SSCertifiable

    Points: 6173

    I had the correct answer selected, then looked it over 1 last time and saw the tags. I changed my answer and promptly got it wrong. To be fair though, if I had thought about it for just another 10 seconds, I would have ignored the tags. They are not in the newsletter.:cool:

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • Rob Goddard

    SSCrazy

    Points: 2572

    Not wanting to be antagonistic or anything, but given the question and answers (ie, what the question is trying to get across), and the fact that the STRONG tag is a well known HTML tag, it doesn't take much to figure it's a badly formatted question as opposed to intended.

    I did actually get it 'right', but I suppose the simple fact is that the code will not run as is, and so anyone that answers "The code needs changing" should be awarded a point until the QotD is updated...

    --------
    [font="Tahoma"]I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams[/font]

  • wim.buyens

    Ten Centuries

    Points: 1139

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near '<'.

    So I think it's the last answer, query need some correction before compile!!!!!

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

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