SQL stored procedure written with temp table

Create procR_productuse_m (@id1 int,@id2 int,@id3 int) asbegin---Temporary table 1SelectA.id1,b.id2,c.id3 into#linshi_1 fromTable_a asA,table_b asB,table_c asCwhereA.id1=@id2---Temporary table 2SelectC.ID3,sum(A.L2),Month(B.L3), B.L1 into#linshi_2 fromTable_a asA,table_b asB,table_c asCwhere[Email protected]Group  by Month(b.13)---ResultsSelect#linshi_1. Id1, #linshi_1. Id2 from#linshi_1 Left Join#linshi_2 on#linshi_1. id1=#linshi_2. Id2EndGo

A # is a local variable, such a temporary table can only be used in this stored procedure

Two # #为全局临时表, can be used outside the stored procedure, you need to manually delete the drop table # #表名

SQL stored procedure written with temp table