SQL Stored Procedures Question:
Determine when to use stored procedure to complete SQL Server tasks?
Answer:
If a large piece of code needs to be performed repeatedly, stored procedures are ideal
When hundreds of lines of SQL code need to be sent; it is better to use stored procedure through a single statement that executes the code in a procedure, rather than by sending hundreds of lines of code over the network.
When security is required.
When hundreds of lines of SQL code need to be sent; it is better to use stored procedure through a single statement that executes the code in a procedure, rather than by sending hundreds of lines of code over the network.
When security is required.
| Previous Question | Next Question |
| What are the purposes and advantages stored procedure? | MS SQL Stored Procedures Job Interview Questions! |