Re: Constraints or assertions
From: Roy Hann <specially_at_processed.almost.meat>
Date: Tue, 05 May 2009 09:51:08 -0500
Message-ID: <bLqdnbsMYMXBz53XnZ2dnUVZ8g-dnZ2d_at_pipex.net>
Date: Tue, 05 May 2009 09:51:08 -0500
Message-ID: <bLqdnbsMYMXBz53XnZ2dnUVZ8g-dnZ2d_at_pipex.net>
AK wrote:
> I have posted a few ideas on implementing business rules in the
> database:
>
> http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/05/04/two-suggestions-to-enhance-constraints-in-sql-server.aspx
>
> I am very interested in feedback.
So you really just want general constraints like in ANSI/ISO SQL92. The standard syntax is CREATE ASSERTION.
I agree that any SQL DBMS would benefit from the ability to enforce general constraints.
-- RoyReceived on Tue May 05 2009 - 16:51:08 CEST