Post reply

Violating Foreign Keys

  • October 24, 2011 at 8:51 pm

    #245213

    Comments posted to this topic are about the item Violating Foreign Keys

  • October 24, 2011 at 8:52 pm

    #1398957

    A lot of reading of the T-SQL but a GOOD question ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • October 25, 2011 at 1:01 am

    #1398974

    Easy and too long question.

  • October 25, 2011 at 1:35 am

    This was removed by the editor as SPAM

  • October 25, 2011 at 4:23 am

    #1399007

    Nice easy question.

    Maybe a bit too long in the sql.

    Tom

  • October 25, 2011 at 4:51 am

    #1399017

    As Paul White would say, this is one of those questions that turns us into a T-SQL parser. 😀

    But nice question.

    Almost got it wrong because I couldn't see the error in query #7 (there were 5 values being passed to 4 columns).

    Thank you.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • October 25, 2011 at 5:57 am

    #1399043

    codebyo (10/25/2011)

    Almost got it wrong because I couldn't see the error in query #7 (there were 5 values being passed to 4 columns).

    #7 fails because personname is declared NOT NULL in the table def, I believe.

    Nice question. Didn't realize that FK constraints aren't checked if a NULL is present, as I don't recall having declared a FK on columns where I allowed nulls.

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

  • October 25, 2011 at 7:01 am

    #1399080

    Rather surprised that as of this posting only 44 percent of those answering had answered correctly.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • October 25, 2011 at 7:42 am

    #1399106

    bitbucket-25253 (10/25/2011)

    Rather surprised that as of this posting only 44 percent of those answering had answered correctly.

    I at least missed it because, in the midst of all of the boxes, I checked the wrong one by mistake.

  • October 25, 2011 at 8:45 am

    #1399151

    Thanks for the question.

    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

  • October 25, 2011 at 8:50 am

    #1399154

    nice question but boy am i glad i had an extra coffee this morning! made me work a little harder today sifting through all the code! 🙂

  • October 25, 2011 at 9:07 am

    #1399161

    Thomas Abraham (10/25/2011)

    #7 fails because personname is declared NOT NULL in the table def, I believe.

    Yes, you're right. I was so sure that there were five values being passed.

    Thanks for the correction.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • October 25, 2011 at 9:10 am

    #1399164

    Ron,

    I missed it because ,

    query 4

    although inserts a record from the second insert statement,

    the first insert statement fails, I guess rendering that query failed,even though something has been inserted.

    This is why 74% missed query 4 , and only 66% missed query 5 and 7.

    Very trickey, also I did the bonehead move of not selecting 3 answers, I need to pay more attention to what the question is asking. :hehe:

  • October 25, 2011 at 9:43 am

    #1399190

    Nice question, took awhile to get through but a nice question nonetheless.

  • October 25, 2011 at 11:43 am

    #1399240

    Nice question - it boils down to attention to detail burried in the code.

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

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