X-Received: by 10.182.186.105 with SMTP id fj9mr213045obc.5.1392140012895; Tue, 11 Feb 2014 09:33:32 -0800 (PST)
X-Received: by 10.182.28.100 with SMTP id a4mr86320obh.28.1392140012693; Tue, 11 Feb 2014 09:33:32 -0800 (PST)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!c10no17759081igq.0!news-out.google.com!vg8ni31igb.0!nntp.google.com!uq10no16227884igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-sqlserver
Date: Tue, 11 Feb 2014 09:33:32 -0800 (PST)
In-Reply-To: <38589a34-3694-4e0e-8b59-c98b9c0b7b25@googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=173.61.139.203; posting-account=SOVadwoAAAB3h7W1MLW9kMYtEc2JW2L8
NNTP-Posting-Host: 173.61.139.203
References: <ldan3d$f0i$1@dont-email.me> <XnsA2D0F0AEE3E6Yazorman@127.0.0.1> <lddcn4$i2b$1@dont-email.me> <cc80175a-413c-46db-92af-2c236f9044d8@googlegroups.com> <38589a34-3694-4e0e-8b59-c98b9c0b7b25@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <f00c36d9-db8f-4f6c-b2b3-5a799ddf6fa2@googlegroups.com>
Subject: Re: A question about relationship
From: Ross Presser <rpresser@gmail.com>
Injection-Date: Tue, 11 Feb 2014 17:33:32 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref: csiph.com comp.databases.ms-sqlserver:1675

On Tuesday, February 11, 2014 11:43:44 AM UTC-5, bradbury9 wrote:
> Well, in fact Orders.CustomerID should be NOT NULL. Althought a demo database
> 
> > CREATE TABLE "Orders" (
> > 	"OrderID" "int" IDENTITY (1, 1) NOT NULL ,
> > 	"CustomerID" nchar (5) NULL , /* This seems to be wrong */
> > 	"EmployeeID" "int" NULL ,
> > 	"OrderDate" "datetime" NULL ,

Oops, I missed that. Good point.