What are the types of Stored Procedures available in SQL Server? Posted in SQL Interview Questions, TSQL Interview Questions by Chandrasekhar Raparthi On August 25, 2016. No comments Types: User-defined Temporary Local Global System Extended user-defined Note: These types might change over the SQL Server versions changes. The above types are based on SQL Server 2016. Click here for the more information. Happy Reading Share this:GooglePinterestEmailTwitterLinkedInFacebook Tags:stored procedures Related Posts Why do we set ANSI_NULLS ON before writing a script? ANSI_NULLS property is used for comparing ANSI NULLS. By How many Instead Of Triggers we can create on a table? Only one Instead of Trigger per operation(Delete/Insert/Update) is possible What is RAISERROR ()? Where do you use this? RAISERROR The name itself RAISERROR is saying that, we Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of follow-up comments by email. Notify me of new posts by email.