eg:
create procedure test1
as
select a,b from tablename
gocreate procedure test2
As
create table #tmp(f1 varchar(20),f2 int)
insert #tmp Exec test1
select * from #tmp
go
create procedure test1
as
select a,b from tablename
gocreate procedure test2
As
create table #tmp(f1 varchar(20),f2 int)
insert #tmp Exec test1
select * from #tmp
go
create procedure test1
as
select a,b from tablename
gocreate procedure test2
As
create table #tmp(f1 varchar(20),f2 int)
insert #tmp Exec test1
select * from #tmp
go
create procedure test1
as
select a,b from tablename
gocreate procedure test2
As
create table #tmp(f1 varchar(20),f2 int)
insert #tmp Exec test1
select * from #tmp
go
as
insert table1 Exec test1
然后在操作就可以了。
如:insert into #tem exec your_Proc