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, 810👍, 0💬
Popular Posts:
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...