--eg
CREATE PROCEDURE sp_searchRealmWeb1_1
@content nvarchar(100),
@count int,
@page int
as
DECLARE @SQL varchar(800)
set @sql='select top '+@count+' * from tablename'
exec(@sql)
CREATE PROCEDURE sp_searchRealmWeb1_1
@content nvarchar(100),
@count int,
@page int
as
DECLARE @SQL varchar(800)
set @sql='select top '+@count+' * from tablename'
exec(@sql)
CREATE PROCEDURE sp_searchRealmWeb1_1 @content nvarchar(100),@count int,@page int
As DECLARE @SQL varchar(800)
Set @SQL='select top '+Rtrim(@count)+' * from db_Article where title like ''%'+@content
+'%'' and checkup=1 and ArticleID not in
(select top '+ Rtrim(@count) + ' ArticleID from db_Article
where title like ''%'+@content+'%'' and checkup=1 )
order by Article desc'
exec(@sql)
@content nvarchar(100),@count int,@page int
as
DECLARE @SQL varchar(800)
set @SQL='
select top '+cast(@count as vachar(100))+' *
from db_Article
where title like '%'+@content+'%' and checkup=1
and ArticleID not in
(select top '+cast(@count*(@page-1) as varchar(100))+' ArticleID from db_Article
where title like '%'+@content+'%' and checkup=1 order by ArticleID desc)
order by Article desc'
go
CREATE PROCEDURE sp_searchRealmWeb1_1 @content nvarchar(100),@count int,@page int as DECLARE @SQL varchar(800)
set @SQL = 'select top ' + cast(@count as varchar(20)) + ' * from db_Article where title like ''%' + cast(@content as varchar(20)) + '%'' and checkup=1 and ArticleID not in
(select top ' + cast(@count as varchar(20)) + ' * (' + cast(@page as varchar(20)) + '-1) ArticleID from db_Article
where title like ''%'+cast(@content as varchar(20)) +'%'' and checkup=1 order by ArticleID desc)
order by Article desc'
exec(@sql)
go
放在SQL中不会有什么问题
但是执行没有结果出现
我也查了一下,没有找到原因
我正在找其它的原因