Groups > comp.databases.ms-sqlserver > #505

Re: SSE 2008: Check Clause Question

From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SSE 2008: Check Clause Question
Date	2011-07-12 15:47 -0700
Organization	A noiseless patient Spider
Message-ID	<kfjp175atlvqc62l72smlpnmn5j0u9ondf@4ax.com> (permalink)
References	<sgap171gthveuafqqeh17jgua36k2ihp49@4ax.com> <Xns9F20F38F7A3FFYazorman@127.0.0.1>

Show all headers | View raw

On Tue, 12 Jul 2011 23:56:34 +0200, Erland Sommarskog
<esquel@sommarskog.se> wrote:

>Gene Wirchenko (genew@ocis.net) writes:
>>      Is there any way around the SQL glitch that a check condition
>> will always succeed when the table is empty?
>> 
>>      I do not want to have the first row be automatically accepted.
> 
>Not sure what you mean. If the table is empty, there is nothing to enforce. 
>That does not mean if you add a row, that anything will be accepted.
>
>Could you clarify?

     That is what I have read.  There is even an example purporting to
show this
          http://msdn.microsoft.com/en-us/library/ms188258.aspx
It appears to be a false alarm.

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SSE 2008: Check Clause Question Gene Wirchenko <genew@ocis.net> - 2011-07-12 13:12 -0700
  Re: SSE 2008: Check Clause Question Erland Sommarskog <esquel@sommarskog.se> - 2011-07-12 23:56 +0200
    Re: SSE 2008: Check Clause Question Gene Wirchenko <genew@ocis.net> - 2011-07-12 15:47 -0700
      Re: SSE 2008: Check Clause Question Erland Sommarskog <esquel@sommarskog.se> - 2011-07-13 10:17 +0200
  Re: SSE 2008: Check Clause Question --CELKO-- <jcelko212@earthlink.net> - 2011-07-14 07:06 -0700
  Re: SSE 2008: Check Clause Question --CELKO-- <jcelko212@earthlink.net> - 2011-07-14 07:12 -0700
    Re: SSE 2008: Check Clause Question "Fred." <ghrno-google@yahoo.com> - 2011-07-14 08:22 -0700
    Re: SSE 2008: Check Clause Question Gene Wirchenko <genew@ocis.net> - 2011-07-14 15:26 -0700
      Re: SSE 2008: Check Clause Question Erland Sommarskog <esquel@sommarskog.se> - 2011-07-15 10:58 +0200
        Re: SSE 2008: Check Clause Question Gene Wirchenko <genew@ocis.net> - 2011-07-15 11:07 -0700
      Re: SSE 2008: Check Clause Question --CELKO-- <jcelko212@earthlink.net> - 2011-07-16 06:46 -0700

csiph-web