Rules Vrs Check Constraints

Hello,
Could someone please explain the difference between them?,
I'm edging towards the CHECK CONSTRAINT as I believe it
offers better perfomance, but I just want to make sure I
have my facts right.
J
Rules is not in ANSI SQL. So you will only find it implemented as in SQL Server in MS and possibly
Sybase SQL Server.
Constraints are ANSI SQL.
Most focus today is on constraints. Many consider rules and "old technology". They have the
advantage of "define once, use many", though.
I prefer constraints.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:10f801c518fa$6b320ce0$a401280a@.phx.gbl...
> Hello,
> Could someone please explain the difference between them?,
> I'm edging towards the CHECK CONSTRAINT as I believe it
> offers better perfomance, but I just want to make sure I
> have my facts right.
> J
|||Thanks Tibor

>--Original Message--
>Rules is not in ANSI SQL. So you will only find it
implemented as in SQL Server in MS and possibly
>Sybase SQL Server.
>Constraints are ANSI SQL.
>Most focus today is on constraints. Many consider rules
and "old technology". They have the
>advantage of "define once, use many", though.
>I prefer constraints.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Julie" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:10f801c518fa$6b320ce0$a401280a@.phx.gbl...
them?,
>
>.
>