What is a Stored Procedure in SQL Server

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.

1 comment
Posted by Jalen on 1/31/2012 9:55:16 AM
I thought I'd have to read a book for a dsiocvery like this!
Leave a comment
Display Name:  



Domain Registrations starting at $9.69
Powered by Carlos Bercero Blog Platform © 2009