SQL Stored Procedures Interview Question:

MS SQL Stored Procedures Job Interview Questions!

Submitted by: Administrator

What are the purposes and advantages stored procedure?
Determine when to use stored procedure to complete SQL Server tasks?
Define Stored procedure?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
In what three ways is the RETURN statement used in a stored procedure?
What security features are available for stored procedure?
Submitted by: Administrator