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>


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.

-- 
Roy
Received on Tue May 05 2009 - 16:51:08 CEST

Original text of this message