Groups > microsoft.public.sqlserver.programming > #31271

Re: Unique Constraint Based on Dual GUID

X-Received	by 10.66.190.7 with SMTP id gm7mr28117854pac.23.1439349211558; Tue, 11 Aug 2015 20:13:31 -0700 (PDT)
X-Received	by 10.140.105.102 with SMTP id b93mr291936qgf.26.1439349211261; Tue, 11 Aug 2015 20:13:31 -0700 (PDT)
Path	csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!pg9no8865113igb.0!news-out.google.com!78ni9297qge.1!nntp.google.com!69no5137325qgl.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	microsoft.public.sqlserver.programming
Date	Tue, 11 Aug 2015 20:13:30 -0700 (PDT)
In-Reply-To	<a6978bfd-b275-468c-9c7d-a4a64b2e9f4a@googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=173.61.135.70; posting-account=SOVadwoAAAB3h7W1MLW9kMYtEc2JW2L8
NNTP-Posting-Host	173.61.135.70
References	<mqbsbp$9va$1@dont-email.me> <a6978bfd-b275-468c-9c7d-a4a64b2e9f4a@googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<cb58131a-eab8-48e9-b21d-f27cb8ede03a@googlegroups.com> (permalink)
Subject	Re: Unique Constraint Based on Dual GUID
From	rpresser <rpresser@gmail.com>
Injection-Date	Wed, 12 Aug 2015 03:13:31 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com microsoft.public.sqlserver.programming:31271

Show key headers only | View raw

On Tuesday, August 11, 2015 at 6:30:24 PM UTC-4, --CELKO-- wrote:

> In SQL, we would have UNIQUE (a, b) and CHECK (a < b) instead. 

Addressing this and only this point you've made, and not addressing flaws
in the original poster's model (which you have already done):

There is no guarantee that the left side GUID actually is less than the
right side; your check constraint would very likely prevent adding references
to the join table.

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Unique Constraint Based on Dual GUID Michael Cole <invalid@invalid.com> - 2015-08-11 14:07 +1000
  Re: Unique Constraint Based on Dual GUID Erland Sommarskog <esquel@sommarskog.se> - 2015-08-11 21:35 +0200
  Re: Unique Constraint Based on Dual GUID rpresser <rpresser@gmail.com> - 2015-08-11 12:46 -0700
  Re: Unique Constraint Based on Dual GUID --CELKO-- <jcelko212@earthlink.net> - 2015-08-11 15:30 -0700
    Re: Unique Constraint Based on Dual GUID rpresser <rpresser@gmail.com> - 2015-08-11 20:13 -0700
  Re: Unique Constraint Based on Dual GUID --CELKO-- <jcelko212@earthlink.net> - 2015-08-12 18:26 -0700
    Re: Unique Constraint Based on Dual GUID Michael Cole <invalid@invalid.com> - 2015-08-13 11:59 +1000

csiph-web