SQL Stored Procedures Question: Download Questions PDF
Determine when to use stored procedure to complete SQL Server tasks?
![MS SQL Stored Procedures Interview Answer MS SQL Stored Procedures Interview Question](https://globalguideline.com/public/images/interview/29.png)
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.
Download MS SQL Stored Procedures Interview Questions And Answers
PDF
Previous Question | Next Question |
What are the purposes and advantages stored procedure? | MS SQL Stored Procedures Job Interview Questions! |