Different Types of stored procedure sql Server
A stored procedure is a precompiled set of one or more SQL statements that are stored on SQL Server. The benefit of Stored Procedures is that they are executed on the server-side and perform a set of actions, before returning the results to the client-side. This allows a set of actions to be executed with minimum time and also reduces the network traffic. Hence stored procedure improves performance to execute SQL statements. For more about stored procedure refer to the article CRUD Operations using Stored Procedures.
A stored procedures can accept input and output parameters. Stored procedures can return multiple values using output parameters. Using stored procedure, we can Select, Insert, Update, Delete data in the database.
Types of Stored Procedure
Types of Stored Procedure
Extended Procedure
User-Defined Stored Procedure
CLR Stored Procedure
Summary
