Programming Stored Procedure Rules
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
Basic Rules
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 ...
Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
