在T-SQL中需要两级参考

通过使用动态SQL，我创建了这样的变量名：

set @tempresultStore = 'Temp'+@colVar

现在，它@tempresultstore具有值'TempMiddleName'，然后我声明了名为TempMiddleName的变量，并在动态sql查询的同一行中分配了该值并执行了该值。

代码如下：（向下滚动到带注释的代码行以跟踪问题所在）

    CREATE Procedure OutputProcedure

     @LastNameFromUser nvarchar(20) = null, 
     @LastNameFromTable nvarchar(20), 
     @MiddleNameFromUser nvarchar(20) = null, 
     @MiddleNameFromTable nvarchar(20) = null, 
     @CityFromUser nvarchar(20) = null,
      @CityFromTable nvarchar(20) = null,
    @Percentage int out

    AS
    BEGIN
    SELECT @MiddleNameFromTable AS'middlename'
    select @LastNameFromTable as 'LASTNAMEFROMTABLE'
    select @LastNameFromUser as 'LASTNAMEFROMUser'
    select 'OUTPUTPROCEDURECALLED'
    declare @maxvalue int , @finalpercentage int = 0
    DECLARE @variableTable TABLE
     (
        idx int identity(1,1),
        matchvalue nvarchar(15)
        )

        INSERT INTO @variableTable(matchvalue) values ('MiddleName')
        INSERT INTO @variableTable(matchvalue) values ('LastName')
        INSERT INTO @variableTable(matchvalue) values ('City')

        SELECT * FROM @variableTable 
    DECLARE @counter int

    declare @sql nvarchar(100)
    declare @sql2 nvarchar(25), @finalResult nvarchar(100)
    set @finalResult = 0;
    declare @sql3 nvarchar(300), @sql4 nvarchar(15),  @tempresultStore nvarchar(20), @temp int, @temp2 int, @average int
    DECLARE @ParmeterDefinition nvarchar(500);
    set @ParmeterDefinition = 
    N'@LastNameFromUsnvarchar(20), 
    @LastNameFromTab nvarchar(20), 
    @MiddleNameFromUs nvarchar(20), 
    @MiddleNameFromTab nvarchar(20), 
    @CityFromUs nvarchar(20),
    @CityFromTab nvarchar(20),
    @Percent int out'


    SET @counter = 1
    SELECT @maxvalue = (SELECT MAX(idx) FROM @variableTable)

    select @maxvalue as 'MAXVALUE'
    WHILE(@counter < @maxvalue)
    BEGIN
        DECLARE @colVar nvarchar(15)

        SELECT @colVar = matchvalue FROM @variableTable WHERE idx = @counter

        set @tempresultStore = 'Temp'+@colVar  --here
        SELECT @tempresultStore AS 'FINALCUTPART'
        select 'JUSTBEFORSQL'
     set @sql3 = 'declare @Temp' + @colVar + ' int = dbo.[Match' + @colVar + '](' + @colVar + 'FromUser,' + @colVar + 'FromTable, 0)' 
    select @sql3 as 'check sql query formed'
     EXEC sp_executesql @sql3, 
    @ParmeterDefinition, 
     @LastNameFromUs = @LastNameFromUser, 
    @LastNameFromTab = @LastNameFromTable, 
    @MiddleNameFromUs = @MiddleNameFromUser, 
    @MiddleNameFromTab  = @MiddleNameFromTable, 
    @CityFromUs = @CityFromUser,
    @CityFromTab  = @CityFromTable,
    @Percent =  @Percentage out
    select @Percentage AS 'PERCENTRETRIVED'
    set @finalResult = @finalResult + @Percentage  /*here @Percentage always remains 0. It is the value returned by the UDF called by the dynamic SQL above.The function does return the value but probably I fail to store it correctly.*/
   select @finalResult as 'SUM'
        SET @counter = @counter + 1
        select @counter as 'COUNTERVALUE'
        END
        set @finalpercentage = @finalResult/@maxvalue
        SELECT @finalpercentage AS 'FINALRESULT'
    RETURN 
    END
     Go 

我如何访问存储在名为int的变量中的int值 @TempMIddleName