34,575
社区成员
发帖
与我相关
我的任务
分享
create procedure x1
as
declare @t table(a1 int)
insert into @t values(1)
insert into @t values(2)
insert into @t values(4)
select a1 from @t
go
create procedure x2
as
declare @tname varchar(50)
set @tname='#'+replace(newid(),'-','')
declare @sql varchar(8000)
set @sql='
create table '+@tname+'(a1 int)
declare @proce_name varchar(40)
set @proce_name = ''x1 ''
insert into '+@tname+' exec @proce_name
select a1 from '+@tname+'
drop table '+@tname
exec (@sql)
go
/************/
exec x2
go
drop proc x1
drop proc x2
create procedure x1
as
declare @t table(a1 int)
insert into @t values(1)
insert into @t values(2)
insert into @t values(4)
select a1 from @t
go
create procedure x2
as
declare @tname varchar(50)
set @tname='#'+replace(newid(),'-','')
declare @sql varchar(8000)
set @sql='
create table '+@tname+'(a1 int)
declare @proce_name varchar(40)
set @proce_name = ''x1 ''
insert into '+@tname+' exec @proce_name
select a1 from '+@tname
exec (@sql)
go
/************/
exec x2
go
drop proc x1
drop proc x2