DECLARE @sql nvarchar(4000),@called_calls INT
SET @sql ='SELECT @a=COUNT(*) FROM users as u where u.client_id=1 '
exec sp_executesql @sql,N'@a int output',@called_calls output
SELECT @called_calls
--@sql 注意类型必须是nvarchar
---N不可少
SQL中将查询结果赋值给变量
最新推荐文章于 2024-08-18 03:35:43 发布