Stored Procedures Interview Questions

• Can a Stored Procedure call itself (recursive). If so then up to what

• Difference between view and stored procedure?

• How do I mark the stored procedure to automatic execution?

• How will know whether the SQL statements are executed?

• How will you handle Errors in Sql Stored Procedure?

• How will you raise an error in sql?

• How you will return XML from Stored Procedure?

• I have Two Stored Procedures SP1 and SP2 as given below. How the

• Nested Triggers

• SQL Server provides three ways to recompile a stored procedure:

• What are the difference between a function and a stored procedure?

• What are the different types of Storage Procedure?

• What is a Function & what are the different user defined functions?

• What is an extended stored procedure? Can you instantiate a COM

• What is Stored procedure?

• When do one need to recompile stored procedure?

• Why one should not prefix user stored procedures with sp_?

Posted in: