What are the Advantages and disadvantages of Stored Procedure (SP)?

This article describes about the advantages and disadvantages of Stored Procedure (SP). Summary of the article:

• Advantages of SP
• Disadvantages of SP

• It is faster
• It is Pre-compiled
• It reduce network traffic
• It is reusable
• It can handle complex operation
• It support nested SP
• It’s security is high. No bode can see the code. Because it stay in Database Server

Disadvantages of SP
The disadvantage of Stored Procedure (SP):

• Need expert developer, Because it is so hard to write code
• It’s debugging is hard
• It is not database independent. Its code may vary based on database server

That’s all about advantages and disadvantages of SP.