Salmon Training Online Books: Sample Chapter

Contents

• 1. Introduction
• 2. Development Database
• 3. First Stored Procedure
  • Introduction
  • Requirements Analysis
  • Table Creation
  • Adding Test Data
  • Coding the Transact-SQL
  • Creating the Procedure
  • Executing the Procedure
  • Examining Procedures
  • Rules for Procedures
  • Input Parameters
  • Default Parameters
  • The Return Code
  • Output Parameters
  • Conclusion
• Design
• Insert Procedures
• Modularization
• Error Processing
• Program Flow
• Update Procedures
• Transactions
• Temporary Tables
• Triggers
• Performance Tuning
• Security

3.14 Conclusion

This chapter has been a tour through many aspects of stored procedure creation. You have seen the creation of a procedure that includes input parameters. The procedure was made more robust through the addition of error processing. We also demonstrated three different ways fo passing data back to the calling process: the result set, the return code and output parameters.

We will be revisiting topics discussed in this chapter in later chapters.

• next >>
• << previous
• Developing Stored Procedures for Microsoft SQL Server (no ads in full eBook)