SQL Stored Procedures – How To Information | eHow.com
Structured query language, or SQL, works with named parameters, so you can pass data back and forth between your desktop and Web applications. These parameters also protect from SQL injection, which is a hack that passes SQL code to the database in an effort to steal data from the tables.
Input and Output in Stored ProceduresMost relational database systems use the Structured Query Language, or SQL, to create database structures, update data and perform reporting and maintenance tasks. Database managers use stored procedures as a way to optimize frequently-used groups of SQL commands. The database keeps the stored procedure in a compiled form that runs faster than SQL submitted from client programs.
Microsoft SQL Server Integration Services automates database processes on your server. Each step executes one process in the SSIS package. To execute a stored procedure, you use the “exec" statement. SSIS packages include SQL code for the process steps, so you just need to add a step and type your exec statement with the stored procedure to use the procedure in the package.