declare @sql nvarchar(max)
declare @nu int
set @sql='SELECT * FROM [FMTest].[dbo].[FM_Radio_Station]'
set @sql='SELECT @nu=count(0) from('+@sql+')aa'
EXEC sp_executesql @sql,N'@nu AS INT OUTPUT',@nu OUTPUT
SELECT @nu
相关文章
- 03-21EXEC sp_executesql
- 03-21转---python os.exec*()家族函数的用法
- 03-21Code::Blocks无法调试 Starting the debuggee failed: No executable specified, use `target exec'
- 03-21tar 解压bz2报错 Cannot exec: No such file or directory
- 03-21正则表达式中的exec()方法
- 03-21内置函数——eval、exec、compile
- 03-21Cypress系列(96)- exec() 命令详解
- 03-21find | xargs 与 find -exec的区别
- 03-21内置函数— — eval、exec、compile
- 03-21内置函数---eval、exec、compile