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
相关文章
- fork和exec
- php curl_exec optimize
- docker exec进程是由谁产生的
- exec 和 spawn 的区别
- Exception in thread "main" brut.androlib.AndrolibException: brut.androlib.AndrolibException: brut.common.BrutException: could not exec command
- [http-nio-8080-exec-4] {dataSource-1} init error
- QT 窗体的show/exec、close/hide,调用close析构没有执行
- K8S问题-kubectl exec命令无法进入pod环境,处于卡住状态
- docker exec :容器中执行命令
- Runtime.getRuntime().exec方法