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?

Advertisements

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 )

Google+ photo

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

Connecting to %s