Writing Stored Procedures for Microsoft SQL Server

Chapter 2. Stored Procedure Camps

IN THIS CHAPTER

• What is business logic?

• Why differences have come about

• The All Business Logic Camp

• The No Business Logic Camp

• Finding middle ground

When working with SQL Server stored procedures, you will discover that most developers are in one of two camps concerning what types of functionality should be provided in stored procedures. You will usually find that the developers in both camps are willing to battle it out to determine the direction in which the development will move on a specific application. Some developers are determined to put as much business logic as possible into stored procedures that they write. Other developers want to put as little functionality as necessary into the stored procedures. Both ...