Re: Rules Vs Check constraints Rules are global, DB-wide
CCs are like field properties...and are faster
>Hello All,
>
> We are migrating Oracle RDB database into MS SQL Server. During
>the process the "Domain" datatype of RDB is more like a user defined
>data type. But we need to add some constaints for these user defined
>datatypes. Should I use "Rules" or "Check Constraints".
>1) MS help says rules are introduced for backward compatibility, will
>they be supported in next versions?
>2)Does usage of rules decline the performance?
>
>Thanks in advance.
>
>Regards
>Sobhan. |