如何将值从SQL Server中的动态SQL返回到变量中 [英] How to return a value into variable from dynamic SQL in SQL server

问题描述

DECLARE @sqlCommand nvarchar(1000)

DECLARE @countnumber int = 0

SET @sqlCommand = 'Set @countnumber = (SELECT count(*) from dsnv)'

EXEC (@sqlCommand)

print @countnumber ;

但我收到错误



我试过的：

But i get error

What I have tried:

DECLARE @sqlCommand nvarchar(1000)

DECLARE @countnumber int = 0

SET @sqlCommand = 'SELECT count(*) into @countnumber from dsnv'

EXEC (@sqlCommand)

print @countnumber ;

但我收到错误

But i get error

推荐答案

试试这个，使用 sp_executesql [ ^ ]

try this, using sp_executesql[^]

DECLARE @sqlCommand nvarchar(1000)
DECLARE @countnumber int = 0
SET @sqlCommand = 'SELECT @countnumber=count(*) from [dsnv]'
EXEC sp_executesql  @sqlCommand ,N'@countnumber int out' , @countnumber out
select @countnumber ;
print @countnumber

这篇关于如何将值从SQL Server中的动态SQL返回到变量中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！