create proc S
@Where varchar(100)
as
begin
Declare @TempTable table(Tid int)
declare @s varchar(1000)
set @s='insert into @TempTable(Tid) select top 10 i_id from tb_res '+@where
exec(@s)
select * from @TempTable
end
@Where varchar(100)
as
begin
Declare @TempTable table(Tid int)
declare @s varchar(1000)
set @s='insert into @TempTable(Tid) select top 10 i_id from tb_res '+@where
exec(@s)
select * from @TempTable
end
create proc S
@Where varchar(100)
as
begin
create table #TempTable(Tid int)
declare @s varchar(1000)
insert #TempTable(Tid)
exec('select top 10 i_id from tb_res '+ @where)
select * from #TempTable
end
@Where varchar(100)
as
begin
Declare @TempTable table(Tid int)
declare @s varchar(1000)
set @s='insert into @TempTable(Tid) select top 10 i_id from tb_res '+@where
exec(@s)
select * from @TempTable
end這樣就可以啦
create proc S
@Where varchar(100)
as
begin
declare @s varchar(1000)
set @s='select top 10 i_id from tb_res '+ @where
exec(@s)
end
明最有错误!
获得临时表后还有后面的工作所以不能像 shuiniu(飞扬的梦)说的那样!谢谢众位了!
@Where varchar(100)
as
begin
Declare @TempTable table(Tid int)
declare @s varchar(1000)
set @s='insert into '+@TempTable(Tid) +'select top 10 i_id from tb_res '+@where
exec(@s)
select * from @TempTable
procedure proc S
@Where varchar(100)
as
begin
create table #TempTable(Tid int)
declare @s varchar(1000)
set @s='insert into #TempTable(Tid) select top 10 i_id from tb_res '+@where
exec(@s)
select * from #TempTable
end
@Where varchar(100)
as
begin
declare @s varchar(1000)
set @s='insert into #TempTable(Tid) select top 10 i_id from tb_res '+@where
exec('create table #TempTable(Tid int)
'+@s+'
select * from #TempTable
')
end