Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days

Stored Procedures

Stored procedures are precompiled SQL statements stored in the database. These statements can be used to insert, select, update, or delete data.

Stored procedures are the SQL equivalent of functions and subroutines in traditional programming languages. They can take and return user-supplied parameters. (Just like a function, a stored procedure is invoked by the application—not automatically by SQL Server.) Using stored procedures you can easily execute a batch of SQL statements in a single line, just as you can call a Visual Basic function or subroutine with a single line of code. This can reduce the amount of repeated code in your application and therefore make your application easier to maintain. This is a benefit subroutines ...