读书人

帮小弟我看看用EXEC命令执行的值返回给

发布时间: 2012-01-19 00:22:28 作者: rapoo

帮我看看用EXEC命令执行的值返回给变量,这样写对吗??
declare @recordcount int
declare @str nvarchar(500)
set @str = N 'select @recordcount = count(*) from [ '+@ToDbName+ '].[dbo].[ProjectInfo] '
exec sp_executesql @str, N '@recordcount int output ', @recordcount output
if (@recordcount =0)
..........

[解决办法]
U r right.

读书人网 >SQL Server

热点推荐