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

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

<wbr></wbr>

<wbr></wbr>

CREATE<wbr> procedure sp_RunDynamicSql_Qzf<br> as<br> begin<br><wbr>declare @i int,@count int<br><wbr>declare @s_var varchar(8000)<br><wbr>declare @s_exec varchar(8000)<br><wbr>select @s_var = '',@s_exec = ''<br><wbr> select @i = 1, @count = count(1) from #tDynamic<br><wbr>if (@count &gt; 100) set @count = 100<br><wbr>while @i&lt;<a href="mailto:=@count">=@count</a><br><wbr>begin<br><wbr><wbr>set @s_var = @s_var + 'declare @s'+left(@i,3)+' varchar(8000) '+char(13)+<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> ' select @s'+left(@i,3)+'=sql from #tDynamic where id='+left(@i,3)+char(13)<br><wbr><br><wbr><wbr>set @s_exec <a href="mailto:=@s_exec">=@s_exec</a>+ <a href="mailto:'+@s'+left(@i,3">'+@s'+left(@i,3</a>)<br><wbr><wbr> set @i = @i + 1<br><wbr>end<br><wbr>set @s_exec = 'exec('+substring(@s_exec,2,datalength(@s_exec))+')'<br><wbr>exec (@s_var + @s_exec<wbr> )<br><wbr>print (@s_var + @s_exec<wbr> )<br> end</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr></wbr>

<wbr></wbr>

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

<wbr></wbr>