When you are developing an application that relies on SQL Server stored procedures, you must take into account a number of rules. Those rules govern the following:
How the stored procedure is created
How objects inside the stored procedure are referenced
How to protect your stored procedure source code from being read
How ODBC interacts with stored procedures
Several rules must be dealt with when creating stored procedures. These rules define the way in which the stored procedure itself is created and how the stored procedure can interact with other objects in the database. The following is a list of the major things you must keep in mind when creating stored procedures:
The CREATE PROCEDURE statement ...