Question of the month June 2015 – When will you use Temporary Stored Procedure?

Many of SQL developers do not know that SQL Server supports temporary stored procedure like temporary tables. A simple example is

create procedure #temp
as
select 1 as number

Have you ever used this? What is the real time use case to have a temporary stored procedure?

One thought on “Question of the month June 2015 – When will you use Temporary Stored Procedure?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s