That's all fine what C. J. Date says, and I'm not disagreeing with that. Stored procedures are good to separate the logical view of the data from the physical layout. Which is a totally different issue then where you have your business rules.

Stored procedures are good because of their encapsulation. It's the same reason you use accessors to access the state of your objects, instead of exposing the innards.

Abigail