Declare @tcount int
set @tcount=1
Declare @sql varchar(100)
set @sql= 'select count(*) from Product '
Execute @[email protected]
这样提示找不到存储过程
而我这里不需要用存储过程来实现
请大家帮助，谢了
------解决方案--------------------
Declare @tcount int
Declare @sql nvarchar(100)
set @sql=N 'select @tcount = count(*) from Product '
Execute sp_executesql @sql,N '@tcount int OUTPUT ',@tcount OUTPUT
SELECT @tcount
------解决方案--------------------
----例子---
use pubs
Declare @tcount int
Declare @sql nvarchar(100)
set @sql=N 'select @tcount = count(*) from jobs '
Execute sp_executesql @sql,N '@tcount int OUTPUT ',@tcount OUTPUT
SELECT @tcount
------解决方案--------------------
Declare @tcount int
set @tcount=1
Declare @sql nvarchar(100)
set @sql= 'select count(*) from Product '
exec sp_executesql @sql,N '@tcount int output ',@tcount output
print @tcount