2005可以运行,但2000不能运行的语句.求解答..

[xiaoZZzz]

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 @t1 table(a1 int)
declare @proce_name varchar(40)
set @proce_name = 'x1'

insert into @t1 exec @proce_name

select a1 from @t1
go

/************/
exec x2

go

---------
2000里说存储过程结果不能作为源插入表变量..但是2005可以..求解 .

[子陌红尘]

把表变量换作临时表.

[jinjazz]

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

[jinjazz]

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

[dobear_0922]

用临时表吧，，，

[hb_gx]

insert into @t1 exec @proce_name

这个是Sql2005所支持的，但是在Sql2000中还没有那么先进，所以如果在Sql2000使用请改成临时表