UC知道存储过程返回总记录问题？
来源：百度知道 编辑：UC知道 时间：2024/05/12 11:28:07
Declare @tbname varchar(50)
Declare @Col varchar(100)
Declare @TotalRecord int output
set @tbname='book'
set @Col="id"
Select @TotalRecord=count(@Col) From @tbname
为什么提示@tbname为定义
Declare @Col varchar(100)
Declare @TotalRecord int output
set @tbname='book'
set @Col="id"
Select @TotalRecord=count(@Col) From @tbname
为什么提示@tbname为定义
--在sql2000/sql2005中可以如下
Declare @tbname varchar(50)
Declare @Col varchar(100)
Declare @TotalRecord int --output
declare @sql nvarchar(4000)
set @tbname = 'Products'
set @sql='select @TotalRecord=count(*) from ' + @tbname
exec sp_executesql @sql,N'@TotalRecord int output',@TotalRecord output
--select @TotalRecord