What are the different types of Storage Procedure?
Temporary Stored Procedures – SQL Server supports two types of temporary procedures: local and global. A local temporary procedure is visible only to the connection that created it. A global temporary procedure is available to all connections. Local temporary procedures are automatically dropped at the end of the current session…. Continue reading