Stored procedures

A stored procedure is a group of Transact-SQL statements compiled into a single execution plan. Using a stored procedure instead of executing a SQL statement directly can provide the following benefits:

• Better performance

• Reduced network overhead

• Better consistency

• Better accuracy

• Additional functionality