According to C.J. Date in
,
ideally all business rules would be expressed by declared database constraints rather than by stored procedures, "Declarative is better than procedural!" But given a choice between stored procedures and enforcing the rules over and over in each application that uses the database (and then probably missing some cases), the stored procedures seem like a win.