The No Business Logic Camp
At the other end of the stored procedure spectrum lies the camp that wants no part of application or business logic in the database. This camp wants the database to do nothing but store data. At the farthest end of this spectrum, you will find developers who go as far as to require that the application take care of all referential integrity. Most developers do not go this far, but they are out there.
After many developers and administrators were burned by putting all the logic into the database, many of them moved toward putting all the logic into the client. This made for an extremely fat client and an extremely thin database layer. All the database does in this scenario is store data. No advantage is taken of the ...
Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
