O'Reilly logo

Writing Stored Procedures for Microsoft SQL Server by Matthew Shepker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required