Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
emanaton
Starting Member
8 Posts |
 Posted - 2002-11-06 : 15:05:48
|
| Hey gang! =o)I'm trying to generate some ideas here and was wondering if anyone would like to participate in the brainstorming, so to speak. At my place of work, we have a product with a VB front end and a SQL back end. For the most part, the business rules are applied in the Add / Update stored procedures in SQL. I am now doing further development on the data import and validation processes.What I want to do is to centralize all of our business rules. My current thinking is that I could build a stored procedure that knows how to execute rules (i.e. check for null, check for certain length, etc.) and then store all of the rules in a table which indicates what object (field, table, etc.) gets what business rule applied.Any ideas? Has anyone else had to tackle this sort of issue before? If so, would you mind sharing your approach?Many thanks,Sean P. O. MacCath-Moran |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
How to centralize business rules?