O'Reilly logo

Building the Agile Database: How to Build a Successful Application Using Agile Without Sacrificing Data Management by Larry Burns

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Fundamental Stored Procedures are special stored procedures that handle updating of data in the database. More specifically, each fundamental stored procedure (or FSP) performs one type of update (add, change, or delete) on one or more rows of data in a single database table. Fundamental stored procedures have the following characteristics:

·         Restricted updates. An FSP should update only one, or at most a small number, of records in a single database table, based on the value(s) of one or more key columns. If, for example, a table has a three-part key, it is permissible to create FSPs that operate on the subset of records defined by the values of one or two of those keys, as long as the possible number of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required