create PRoc R_ProductUse_M(@id1 int,@id2 int,@id3 int)asbegin---臨時表1select a.id1,b.id2,c.id3 into #linshi_1from table_a as a,table_b as b,table_c as cwhere a.id1=@id2---臨時表2select c.id3,sum(a.l2),month(b.l3),b.l1 into #linshi_2from table_a as a,table_b as b,table_c as cwhere a.id1=@id1group by month(b.13)---結果select #linshi_1.id1,#linshi_1.id2from #linshi_1 left join #linshi_2 on #linshi_1.id1=#linshi_2.id2endgo

一個#為局部變量、這樣的臨時表只能在該存儲過程中使用

二個##為全局臨時表，可以在存儲過程外使用，需要手動刪除 drop table ##表名