3 out of 8 rated this helpful - Rate this topic

Stored Procedures (Database Engine)

SQL Server 2008 R2

When you create an application with Microsoft SQL Server, the Transact-SQL programming language is the primary programming interface between your applications and the Microsoft SQL Server database. When you use Transact-SQL programs, two methods are available for storing and executing the programs.

You can store the programs locally and create applications that send the commands to SQL Server and process the results.
You can store the programs as stored procedures in SQL Server and create applications that execute the stored procedures and process the results.

In This Section

This section provides the information necessary to understand, design, and implement stored procedures.

Understanding Stored Procedures: Explains stored procedure concepts and includes descriptions and examples of each stored procedure type available in SQL Server.
Designing Stored Procedures (Database Engine): Provides specific guidelines, rules, and restrictions you should know when designing a stored procedure.
Implementing Stored Procedures: Describes how to create, modify, or delete a stored procedure.

Other Resources

Troubleshooting (Database Engine)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD