34,588
社区成员
发帖
与我相关
我的任务
分享
Create PROCEDURE a
....
insert #temp
exec b
...
Create PROCEDURE b
..
@sql = ...
insert #temp
exec @sql
..
select top 0 * into test from sysobjects
go
create proc a
as
exec ('b')
go
create proc b
as
insert into test
exec ('select * from sysobjects')
go
exec a
drop table test
drop proc a
drop proc b
create proc p
as
select * from sysobjects
go
select top 0 * into test from sysobjects
insert into test exec ('p')
select * from test
drop table test
drop proc p