SQL Stored Procedures Interview Question:

Determine when to use stored procedure to complete SQL Server tasks?

Submitted by: Administrator

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.
Submitted by: Administrator