What are the pros and cons of stored procedure Sql server?
What are the advantages and disadvantages of stored procedures in the SQL server? Please explain to me why I should use it in my code?
I use the stored procedure daily because of some pros feature below:
- Very secure, you can avoid attack SQL injection.
- Faster, because SP is pre-compiled and it is store in the server so when we call SP, we only determine SP name and parameter, this help request is faster.
- Support full CRUD
- Because it stores in the server so it makes the server heavy and only executes it in that server.Marry Christ Oct 19 2020