把存储过程得到的结果集插入到临时表中

把存储过程得到的结果集插入到临时表中

 

create proc p_1

as

select * from branch

go

select * into #1 from branch where 1=2

insert #1

exec('p_1')

select * from #1