What Are Stored Procedures in SQL Server

Q

What Are Stored Procedures in SQL Server Transact-SQL?

✍: FYIcenter.com

A

A stored procedure is a collection of Transact-SQL statements that stored in the SQL Server. A stored procedure can be executed later with an EXEC statement. SQL Server supports stored procedures with the following features:

1. Stored procedures can be divided into 3 groups based their accessing scopes:

  • Permanent Procedures - Created for permanent use.
  • Global Temporary Procedures - Created for temporary use within all sessions.
  • Local Temporary Procedures - Created for temporary use within the same session.

2. Stored procedures can take input parameters.

3. Stored procedures can take output parameters.

4. Stored procedures can be mapped to references to Microsoft .NET Framework common language runtime (CLR) methods.

 

"CREATE PROCEDURE" - Creating Simple Stored Procedures in SQL Server

Using Stored Procedures in SQL Server Transact-SQL

Using Stored Procedures in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2017-01-11, 1608🔥, 0💬