SET VAlue到变量里面执行sql语句 [英] SET VAlue to variable inside execute sql statement

问题描述

我在动态sql语句之外声明了变量，但是我在动态sql语句中为它赋值但是值没有存储在变量中

  DECLARE  @value INT 
  SET  @ParmDefinition = N < span class =code-comment>'  @ value INT' 
  SET  @SQL = N '   
  SET  @ value =  555  '   
 PRINT @SQL 
 
 EXEC [dbo] .sp_executesql @ SQL，@ ParmDefinition，
 @ value = @ value; 

解决方案

将此参数设置为OUTPUT，否则您将无法将结果输入变量

I have declared variable outside the dynamic sql statement, but i am assigning value to it inside the dynamic sql statement but the value is not storing in the variable

DECLARE @value INT
         SET @ParmDefinition = N'@value INT'
         SET @SQL = N'
         SET @value= 555'
                        PRINT @SQL

            EXEC [dbo].sp_executesql @SQL, @ParmDefinition,
            @value=@value;

解决方案

Set this paramenter as OUTPUT, else you will not get result into your variablle

这篇关于SET VAlue到变量里面执行sql语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！