将值从EXECUTESQL分配给另一个变量 [英] Assigne value from EXECUTESQL to another variable

问题描述

我有以下查询:

I have following querry:

DECLARE @A int
Declare @R int
EXEC SP_EXECUTESQL N''select new from tblMRM where [year]=year(getdate()) and [month]=CONVERT(CHAR(4), getdate(), 100)'', N''@A VARCHAR(10) OUTPUT'', @A OUTPUT
select @A

它具有以下输出:

it has following output:

new
0
(No column name)
NULL

当我执行查询而不选择@A时，它很好并且输出为
0
但是当我使用Select @A时，输出为
NULL

我如何获得此查询结果

请帮助...

When I execute query without select @A,its fine and output is
0
but when I use Select @A, output is
NULL

how can i get this query result

Please Help...

推荐答案

尝试以下查询:-

try below query:-

DECLARE @A int
Declare @R int
EXEC SP_EXECUTESQL N'select @A=new from tblMRM where [year]=year(getdate()) and [month]=CONVERT(CHAR(4), getdate(), 100)', N'@A VARCHAR(10) OUTPUT', @A OUTPUT
select @A

您的@a是输出参数，必须在sql查询中使用它..

your @a is output parameter and you must use it in sql query..

这篇关于将值从EXECUTESQL分配给另一个变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！