Differ b/w RULE & CONSTRAINT

hi,
Could anybody tell the difference between Rule & Constraint.
Thanks&Regards
Dutt wrote:
> hi,
> Could anybody tell the difference between Rule & Constraint.
> Thanks&Regards
Rules are a legacy feature that Microsoft has said they will remove
from a future version. It is recommended that you don't use rules, use
check constraints instead. The most obvious difference was that rules
could be bound to user-defined datatypes. User-defined datatypes
(pre-2005 style) are also deprecated.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

Differ b/w RULE & CONSTRAINT

hi,
Could anybody tell the difference between Rule & Constraint.
Thanks&RegardsDutt wrote:
> hi,
> Could anybody tell the difference between Rule & Constraint.
> Thanks&Regards
Rules are a legacy feature that Microsoft has said they will remove
from a future version. It is recommended that you don't use rules, use
check constraints instead. The most obvious difference was that rules
could be bound to user-defined datatypes. User-defined datatypes
(pre-2005 style) are also deprecated.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Differ b/w RULE & CONSTRAINT

hi,
Could anybody tell the difference between Rule & Constraint.
Thanks&RegardsDutt wrote:
> hi,
> Could anybody tell the difference between Rule & Constraint.
> Thanks&Regards
Rules are a legacy feature that Microsoft has said they will remove
from a future version. It is recommended that you don't use rules, use
check constraints instead. The most obvious difference was that rules
could be bound to user-defined datatypes. User-defined datatypes
(pre-2005 style) are also deprecated.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--