阅读背景:

获取存储在SQL Sproc中的变量名的值

来源:互联网 

This is what I am trying to do

这就是我想要做的

  
Declare @Var varchar(50)
Declare @Num1 varchar(50)
Declare @Num2 varchar(50)
Declare @Counter smallint

Set @Counter=1
Set @Num1='Hello'
Set @Num2='Hi'

while (@Counter<2)
 begin
   Set @Var=N'@Num'+convert(varchar,@Counter)
   //Now I want to get the value of '@Num1' that is stored in @Var when @Counter=1
   //Help Needed
 Set @Counter=@Counter+1
 end




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: