获取动态语句中的变量值
DECLARE @Counts INT
EXEC sp_executesql N'select @Counts=count(1) from tbName',N'@Counts int out',@Counts OUT
SELECT @Counts
DECLARE @Counts INT
EXEC sp_executesql N'select @Counts=count(1) from tbName',N'@Counts int out',@Counts OUT
SELECT @Counts