What are the advantages and disadvantages of Stored Procedure?

Last Post

Posts: 12

kumar BI

Guest

Topic starter

Aug 04, 2020 10:57 am

(@kumar BI)

Active Member

Joined: 3 years ago

Stored Procedure Advantages and Disadvantages

Topic Tags

storedprocedureadvantages storedproceduredisadvant

1 Reply

Posts: 36

Siva Kumar

Guest

Aug 05, 2020 5:19 am

(@Siva Kumar)

Eminent Member

Joined: 3 years ago

Here are the Disadvantage and Advantages of stored procedures in SQL Server

Advantages

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.

Disadvantage:
The only disadvantage of Stored Procedure is that it can be executed only in the database and utilizes more memory in the database server.