Collections:
What Are Stored Procedures in SQL Server
What Are Stored Procedures in SQL Server Transact-SQL?
✍: FYIcenter.com
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:
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.
Â
2017-01-11, 1122👍, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...