What are the advant...
Clear all

What are the advantages and disadvantages of Stored Procedure?

kumar BI
Posts: 12
 kumar BI
Topic starter
(@kumar BI)
Joined: 1 year ago

Stored Procedure Advantages and Disadvantages

1 Reply
Siva Kumar
Posts: 36
 Siva Kumar
(@Siva Kumar)
Joined: 1 year ago

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.