Interview Questions with Answers

Clear interview with 100% confidence

Skip to content

Interview questions

Stored Procedures Interview Questions

Please click on question to know the answer.

< 1 2 >

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:

< 1 2 >

Interview Questions
- Interview questions

Powered by WordPress. Built on the Thematic Theme Framework.