EXEC + SQL得到返回值

declare @re varhcar(10),@sql nvarchar(1000)

SET @sql = N'SELECT @re = count(*) FROM TableName'
EXEC sp_executesql @sql,N'@re varhcar(10) output',@re output

print @re