执行搜索查询,以分页的显示返回
CREATE PROCEDURE GetNewsByTitle
@KeyWord varchar(1000),
@News_state int =1,
@PageSize int = 10, -- 页尺寸
@PageIndex int = 1
AS
declare @strSQL varchar(1000) -- 主语句
set @strSQL = "SELECT TOP "
+str(@PageSize)+" News_ID,News_title,News_Body,News_addtime,News_editor,News_Summary from News_News where CHARINDEX(@KeyWord , i.News_title) > 0 and News_state ="
+str(@News_state)+ " and (News_ID not in (select top "+ str((@PageIndex - 1)*@PageSize) + " News_ID from News_News where CHARINDEX(@KeyWord , i.News_title) > 0 and News_state ="
+str(@News_state)+" ORDER BY News_ID DESC) ) order by Rank desc "exec (@strSQL)
GO错误为:
以 ' News_ID,News_title,News_Body,News_addtime,News_editor,News_Summary from News_News where CHARINDEX(@KeyWord , i.News_title) > 0' 开头的 标识符 太长。最大长度为 128。该怎么修改啊?
CREATE PROCEDURE GetNewsByTitle
@KeyWord varchar(1000),
@News_state int =1,
@PageSize int = 10, -- 页尺寸
@PageIndex int = 1
AS
declare @strSQL varchar(1000) -- 主语句
set @strSQL = "SELECT TOP "
+str(@PageSize)+" News_ID,News_title,News_Body,News_addtime,News_editor,News_Summary from News_News where CHARINDEX(@KeyWord , i.News_title) > 0 and News_state ="
+str(@News_state)+ " and (News_ID not in (select top "+ str((@PageIndex - 1)*@PageSize) + " News_ID from News_News where CHARINDEX(@KeyWord , i.News_title) > 0 and News_state ="
+str(@News_state)+" ORDER BY News_ID DESC) ) order by Rank desc "exec (@strSQL)
GO错误为:
以 ' News_ID,News_title,News_Body,News_addtime,News_editor,News_Summary from News_News where CHARINDEX(@KeyWord , i.News_title) > 0' 开头的 标识符 太长。最大长度为 128。该怎么修改啊?
解决方案 »
- 老问题event.clientX在火狐或者IE9下取值都是空
- 纳闷了,研究petshop,竟然发现一个函数定义的时候没定义返回类型,也没有void关键字。你们来看看。
- 在asp.net中的三层框架数据库层实现有那些方法呢,请爷们赐教!
- 请教个session的问题
- 有没有工具直接生成NHibernater的XML以及实体类吗??
- 如何在cs窗体和html之间传值和传参
- 在javascript里怎么传参数?我一传就出错了!
- 在线等:如何合并查询结果:查询结果=查询结果1+查询结果2+查询结果3
- 伯乐在此恭候,千里马指日可求
- 再现回答,一道棘手问题!高分
- 一个小问题~!~!~!~!~!~!~!
- VS.NET2003怎样用正则表达式替换?
2.其中的i.News_title中的i从哪里来?
3.你用了not in ,这将会非常的慢,建议优化
....+ str((@PageIndex - 1)*@PageSize) + " News_ID from News_News where CHARINDEX(@KeyWord , i.News_title) > 0 and News_state ="
....
)+" News_ID,News_title,News_Body,News_addtime,News_editor,News_Summary from
换成“* from"
就可以了,不过感觉不是很舒服ps:当我想获得自定义分页的SQL语句不使用not in怎么实现呢?