What is a Stored Procedure in SQL Server

11/17/2009 2:00:46 PM

A Stored Procedure is a single or a set of SQL statements typically involving some (or a lot of) logic typically designed to accomplish a business data operation. Think of it as a T-SQL script stored in the database itself. Best practices suggests that all data-centric business logic operations should be encapsulated in stored procedures at the database level.