What are the advantages and disadvantages of Stored Procedure?
Stored Procedure Advantages and Disadvantages
Here are the Disadvantage and Advantages of stored procedures in SQL Server
Stored Procedure can be used as modular programming which means create once, store, and call several times whenever it is required. This supports faster execution. It also reduces network traffic and provides better security to the data.
The only disadvantage of Stored Procedure is that it can be executed only in the database and utilizes more memory in the database server.