Posted by Tom Moreau on 03/20/06 14:40

Change it to:

CHECK (R_ID1 = R_ID OR R_ID1 IS NULL),

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Susanne Klemm" <Susanne.Klemm@appliedsystems.de> wrote in message
news:441e9f63$0$43596$bfcc4b32@reader.news.celox.de...
Hi!

I have a table with a check constraint. But unfortunately it does not
work like I wanted.


CREATE TABLE MAP
(
[R_ID] [T_D_ID] NOT NULL,
[R_ID1] [T_D_ID] NULL,
CONSTRAINT CHECK_ID1 CHECK (R_ID1 = R_ID OR R_ID1 = NULL),
CONSTRAINT [PK_MAP] PRIMARY KEY ([R_ID])
)

R_ID1 should always have the value of R_ID or Null
The following statements should cause errors:

insert into map (R_ID, R_ID1)values(1,2);
update map set R_ID1=3 where R_ID=1;

But there occur no errors. Does anyone have an idea? It is an SQL Server
2000.

TIA
Susanne

• Next in forum: Re: Check constraint does not work (compare with null)
• Prev in forum: Re: waittype=WRITELOG
• Thread view: Re: Check constraint does not work (compare with null)

[Reply to this message]