declare @RecordCount int
declare @RecordCount1 nvarchar(50)
declare @sql nvarchar(1000)
if(@sortId=0)
--select @RecordCount=count(ID) from Spzs
set @sql=N'select @RecordCount=count('+@ID+') from '+@tableName+' where '+@keywordName+' like '+'''%'+@keywordValue+'%'''
else
set @sql=N'select @RecordCount=count('+@ID+') from '+@tableName+' where ('+@keywordName+' like '+'''%'+@keywordValue+'%'''+') and (mainClass='+cast(@sortId as varchar(100))+')'
--select @RecordCount=count(ID) from Spzs--select @RecordCount
--Exec sp_executesql @sql,@RecordCount output
Exec sp_executesql @sql,N'@RecordCount int out',@RecordCount out
declare @RecordCount1 nvarchar(50)
declare @sql nvarchar(1000)
if(@sortId=0)
--select @RecordCount=count(ID) from Spzs
set @sql=N'select @RecordCount=count('+@ID+') from '+@tableName+' where '+@keywordName+' like '+'''%'+@keywordValue+'%'''
else
set @sql=N'select @RecordCount=count('+@ID+') from '+@tableName+' where ('+@keywordName+' like '+'''%'+@keywordValue+'%'''+') and (mainClass='+cast(@sortId as varchar(100))+')'
--select @RecordCount=count(ID) from Spzs--select @RecordCount
--Exec sp_executesql @sql,@RecordCount output
Exec sp_executesql @sql,N'@RecordCount int out',@RecordCount out
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货