Re: 'with check option' constraint
From: Tony Rogerson <tonyrogerson_at_torver.net>
Date: Tue, 22 Nov 2005 09:29:03 -0000
Message-ID: <dluo34$s7a$1$8302bc10_at_news.demon.co.uk>
Date: Tue, 22 Nov 2005 09:29:03 -0000
Message-ID: <dluo34$s7a$1$8302bc10_at_news.demon.co.uk>
you could probably do something with an instead of trigger, depends what you are doing.
-- Tony Rogerson SQL Server MVP http://sqlserverfaq.com - free video tutorials "Carl Federl" <cfederl_at_yahoo.com> wrote in message news:1132610415.581490.122750_at_g44g2000cwa.googlegroups.com...Received on Tue Nov 22 2005 - 10:29:03 CET
> Oracle, Ocelot, and SQL Anywhere support defering check constraints
> until commit.
>
> Definitely not supported by DB2 or MS SQL Server.
>
> MS SQL Server does allow disabling a constraint, but the disabling
> applies to all connections and is not automatically re-enabled on
> commit.
>