Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!feeder.ecngs.de!ecngs!feeder2.ecngs.de!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!backlog2.nntp.dca.giganews.com!nntp.pipex.net!news.pipex.net.POSTED!not-for-mail NNTP-Posting-Date: Tue, 05 May 2009 09:51:08 -0500 Newsgroups: comp.databases.theory From: Roy Hann Subject: Re: Constraints or assertions References: <39ef9877-5922-4a7e-b2ca-6708170f0e1e@v4g2000vba.googlegroups.com> User-Agent: XPN/1.0.0 (Monkey Business ; Windows) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Message-ID: Date: Tue, 05 May 2009 09:51:08 -0500 Lines: 19 X-Usenet-Provider: http://www.giganews.com NNTP-Posting-Host: 82.133.118.245 X-Trace: sv3-iYRJU5rq3q73xdE7eKYjxBo7KWRgb+hHJugSeR7YmlB28KQtn9MgwO0RAmIJNPWsHQUlrhNG/SJ182/!6hTtaAkWmTYaDJedwlrtNzunmySDXKvjMUvw4TvhEW+8yjY0jM4yIMnPxOrFYpUK/gWXSNgqtdOK!7sTOTQI5cQpoMtIVpwA4 X-Complaints-To: abuse@dsl.pipex.net X-DMCA-Complaints-To: abuse@dsl.pipex.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.39 Xref: news.cambrium.nl 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