This is a guide to building and using stored procedures in SQL server applications. Stored procedures are used for a variety of complex data gathering tasks, to optimize performance.