Create temp table in sql server

Temporary stored procedure is a little known feature of SQL Server.  This article is an attempt to throw some light on this interesting feature.

Temporary stored procedures are like normal stored procedures but, as their name suggests, have fleeting existence.

There are two kinds of temporary stored procedures local and global. Temporary stored procedures are created just like any other SPs; however the name must begin with a hash (#) for a local temporary SP and two hashes (##) for a global temporary stored procedure.

A local temporary stored procedure is available only in the current session and is dropped when the session is closed.

A global temporary stored procedure is visible to all sessions and is dropped when the session of the user that created it is closed. If there are any executing versions of the global stored procedure when the creator session is closed, those are allowed to complete, but once they are done and the creator session is closed, no further execution of the global temporary stored procedure is allowed.

Aside f

insert into temp table sql server stored procedure

how to create temporary table in sql server using stored procedure