Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: SSE 2008: Check Clause Question

Cross-posted to 2 groups.

Show all headers | View raw

On Thu, 14 Jul 2011 07:12:12 -0700 (PDT), --CELKO--
<jcelko212@earthlink.net> wrote:

>On Jul 12, 3:12 pm, Gene Wirchenko <ge...@ocis.net> wrote:
>> Dear SQL'ers:
>>
>>      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.

>Glitch? That is a law of logic; anything you say about non-existing
>thigns is true. Look up "Existental import" in a text book on the

     It would be a glitch if it turned out to be truth.  A vacuous
truth is irrelevant.

>history of modern logic. And teh first row is not always accepted.

     I have now read that it is in two places.  Given the weirdnesses
and dysfunctionalities of SQL, it was not unbelieveable.  I am glad it
is wrong.

> I have some situations with self-references to avoid gaps in the
>dates of a history that I start with CHECK() constraints off, insert a
>first row, turn teh DRI back on and proceed to insert as usual.

     Please expand "DRI".

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