Business Rules  «Prev  Next»
Lesson 1

Introduction to Stored Procedures using SQL-Server

You will find that much of your database programming involves reissuing the same commands over and over. This is because most businesses tend to adopt uniform ways of handling the many transactions that occur day to day.
Stored procedures can be used to automate repetitive tasks and to make them faster and easier. You can also use stored procedures to automate the process of enforcing business rules. Proper development and usage of stored procedures can save you time and allow you to focus your programming skills on more interesting programming tasks.

Learning objectives

Introduction to Stored Procedures
After completing this module, you will be able to:
  1. Describe and define stored procedures
  2. Enforce business rules
  3. Create, modify, and delete stored procedures
  4. Use input and output parameters
  5. Test your stored procedures
In the next lesson I will discuss what a stored procedure is and how it is used.