Forum

What are the advant...
 
Share:
Notifications
Clear all

What are the advantages and disadvantages of Stored Procedure?


Posts: 12
Guest
Topic starter
(@kumar BI)
Active Member
Joined: 5 years ago

Stored Procedure Advantages and Disadvantages

1 Reply
Posts: 36
Guest
(@Siva Kumar)
Eminent Member
Joined: 5 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.

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: