Post reply

Constraints

  • October 15, 2011 at 6:47 pm

    #244732

    Comments posted to this topic are about the item Constraints

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

  • October 16, 2011 at 7:08 am

    #1395058

    Thanks, good question.

    M&M

  • October 17, 2011 at 12:02 am

    #1395139

    Cool!!!

  • October 17, 2011 at 1:45 am

    #1395166

    Thanks, a very good question!

  • October 17, 2011 at 1:49 am

    #1395167

    Very good question

    I shouldn't try to think this early!

    Tom

  • October 17, 2011 at 1:58 am

    This was removed by the editor as SPAM

  • October 17, 2011 at 2:51 am

    #1395189

    Thought this was straightforward but sadly not

    Surprised that the NULL was not caught in the check constraint...

    More coffee required.

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.

  • October 17, 2011 at 3:31 am

    #1395201

    Had already had first coffee before attempting to answer this. 😀

    Good question, thanks

    Nigel
    How to post questions

  • October 17, 2011 at 4:36 am

    #1395223

    good and easy question!!!

    thanks!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • October 17, 2011 at 5:44 am

    #1395245

    Thanks for the question. I was pretty sure the check constraint would allow the NULL value.

    http://brittcluff.blogspot.com/

  • October 17, 2011 at 5:48 am

    #1395248

    From http://msdn.microsoft.com/en-us/library/ms188258.aspx:

    CHECK constraints reject values that evaluate to FALSE. Because null values evaluate to UNKNOWN, their presence in expressions may override a constraint. For example, suppose you place a constraint on an int column MyColumn specifying that MyColumn can contain only the value 10 (MyColumn = 10). If you insert the value NULL into MyColumn, the Database Engine inserts NULL and does not return an error.

  • October 17, 2011 at 6:03 am

    #1395252

    Good and easy Question !!!

    Thx

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • October 17, 2011 at 6:30 am

    #1395267

    Great question. I got it right, but only because I have encountered this behavior before, and committed it to memory.

    Thanks,

    Matt

  • October 17, 2011 at 6:55 am

    #1395284

    Thanks for a good question. I got it right, but I thought that perhaps only one such NULL INSERT would be allowed. After reading the BOL entry and trying it out, I see that you can INSERT many such rows.

    Odd behavior, at least to me, as it seems the "correct" interpretation of this should be "only permit the INSERT if the constraint condition evaluates to TRUE."

    Anyone here know if this is an ANSI-compliant implementation? Is this how constraints work in MySQL, Oracle, DB2? Just curious....

    Learned something new and got my point!

    Rich

  • October 17, 2011 at 7:07 am

    #1395293

    I guess the answer is wrong

    It should be 1 and 2 only

    beacuse only the constraint is violated,

    the sql statement is terminated.

    it doesn't look for other statements...

    just goes out of loop.

    Just wat i think this, bcoz i encountered this before..

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

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

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