动态声明sql变量，动态执行任意大…

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

 

 

CREATE  procedure sp_RunDynamicSql_Qzf
as
begin
 declare @i int,@count int
 declare @s_var varchar(8000)
 declare @s_exec varchar(8000)
 select @s_var = '',@s_exec = ''
  select @i = 1, @count = count(1) from #tDynamic
 if (@count > 100) set @count = 100
 while @i<=@count
 begin
  set @s_var = @s_var + 'declare @s'+left(@i,3)+' varchar(8000) '+char(13)+
              ' select @s'+left(@i,3)+'=sql from #tDynamic where id='+left(@i,3)+char(13)
 
  set @s_exec =@s_exec+ '+@s'+left(@i,3)
   set @i = @i + 1
 end
 set @s_exec = 'exec('+substring(@s_exec,2,datalength(@s_exec))+')'
 exec (@s_var + @s_exec  )
 print (@s_var + @s_exec  )
end

 

 

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO