declare @sql nvarchar(500)--改类型
declare @outTotalNum int
declare @SearchKey varchar(500) --
set @sql = N'SELECT @TotalNum=COUNT(*) FROM BookShop_Book WHERE 1=1 '
execute sp_executeSql @sql,N'@TotalNum int output',@TotalNum= output--这里有点问题
declare @outTotalNum int
declare @SearchKey varchar(500) --
set @sql = N'SELECT @TotalNum=COUNT(*) FROM BookShop_Book WHERE 1=1 '
execute sp_executeSql @sql,N'@TotalNum int output',@TotalNum= output--这里有点问题
declare @sql nvarchar(500)--改类型
...
execute sp_executeSql @sql,N'@TotalNum int output',@TotalNum output