SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:26 PM
| ||||
| ||||
 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.      |
|
02-28-2008, 05:26 PM
| ||||
| ||||
| Re: Rules Vs Check constraints user extraordinaire (bytehd_im_not_a_spammite@us.net) writes: > Rules are global, DB-wide > CCs are like field properties...and are faster Any test data to back up this statement? -- Erland Sommarskog, SQL Server MVP, sommar@algonet.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp |
Linear Mode
