Question

advantage and disadvantage of stored procedure

Answer 1

the ans is
Advantages of SP
The advantages of Stored Procedure (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

I hope it help you plzz mark me brainliest ans and follow me