Post reply

Unique constraints

  • July 28, 2009 at 9:33 pm

    #208795

    Comments posted to this topic are about the item Unique constraints

  • July 29, 2009 at 12:45 am

    #1031480

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

  • July 29, 2009 at 1:27 am

    #1031487

    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

  • July 29, 2009 at 1:31 am

    #1031489

    tags almost made me choose the wrong option.

    "Keep Trying"

  • July 29, 2009 at 2:04 am

    #1031497

    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!

  • July 29, 2009 at 4:32 am

    #1031530

    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

  • July 29, 2009 at 6:00 am

    #1031570

    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

  • July 29, 2009 at 6:09 am

    #1031580

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

  • July 29, 2009 at 6:35 am

    #1031599

    I am agrry with sjimmo..

  • July 29, 2009 at 6:42 am

    #1031615

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

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

  • July 29, 2009 at 7:10 am

    #1031643

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

  • July 29, 2009 at 7:28 am

    #1031664

    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:

  • July 29, 2009 at 7:31 am

    #1031665

    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

  • July 29, 2009 at 7:32 am

    #1031667

    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]

  • July 29, 2009 at 7:33 am

    #1031668

    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 27 total)

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