This chapter has covered one of the fundamental techniques used in an enterprise database server: executing stored procedures. Having worked through the examples it contains, you should have begun to get a feel for their value, from both a maintenance and an efficiency perspective. Learning to create stored procedures provides an additional development tool that you can use in creating highly scalable systems that perform well even in peak usage times. Stored procedures are used extensively in most database systems, so it is to your advantage to keep working with procedures and getting familiar with them, as it will give you an additional edge when working on projects. In the chapters to come, we'll see some practical applications that will further demonstrate their value. |