Create Procedure sp_Topics_SelectInfoByThemeID
(
@themeid int,
@pageSize int,
@pageNumber int
)
AsSelect Top '+cast(@pageSize as varchar(5))+'
TID,Topic,AddedMember,AddedDate,HitSum,ReplySum,LRMember,LRDate,ThemeID,Up
From Topics Where TID NOT IN
(Select Top '+cast(@pageSize*(@pageNumber-1) as varchar(20))+' TID From Topics
Where ThemeID='+cast(@themeid as varchar(5))+' Order By Up Desc,LRDate Desc,TID Desc)
AND ThemeID='+cast(@themeid as varchar(5))+' Order By Up Desc,LRDate Desc,TID Desc
(
@themeid int,
@pageSize int,
@pageNumber int
)
AsSelect Top '+cast(@pageSize as varchar(5))+'
TID,Topic,AddedMember,AddedDate,HitSum,ReplySum,LRMember,LRDate,ThemeID,Up
From Topics Where TID NOT IN
(Select Top '+cast(@pageSize*(@pageNumber-1) as varchar(20))+' TID From Topics
Where ThemeID='+cast(@themeid as varchar(5))+' Order By Up Desc,LRDate Desc,TID Desc)
AND ThemeID='+cast(@themeid as varchar(5))+' Order By Up Desc,LRDate Desc,TID Desc
解决方案 »
- FckEditor官方网站的上网图片功能为什么不好用(哪位有更好的FckEditor)?
- 急问:.NET 的编译机制,如何能强制编译dll?(重新生成不管用...)
- 前台请求一次,后台持续响应不
- ◎◎◎◎◎◎◎◎--请教高手一个有关SharePoint的问题--◎◎◎◎◎◎◎◎
- 苦恼我半天的问题 各位高手请光临一下 在利用DATAGRID表里的删除命令时 为何提示说 ( 索引超出范围。必须为非负值并小于集合大小)
- 在DataGrid中用模板放了两个DropDownList,如何实现这两个DropDownList的互动??
- 菜鸟求救~~有关用户控件的问题
- 制作的安装程序如何改WebConfig的内容?
- 求一个asp.net留言本或者论坛的源代码
- DataGrid控件中有没有把选择项的按钮风格改变成checkbox或radio?
- 关于Image控件的简单问题
- 求"查找替换"简单功能!
服务器: 消息 170,级别 15,状态 1,过程 sp_Topics_SelectInfoByThemeID,行 9
第 9 行: '+ cast(@pageSize as varchar(5)) +' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,过程 sp_Topics_SelectInfoByThemeID,行 12
第 12 行: '+cast(@pageSize*(@pageNumber-1) as varchar(20))+' 附近有语法错误。
可拼好sql语句再动态执行。
declare @sql varchar(600)
set @sql='Select Top ' + @Quantity + ' Article_ID,User_ID,User_Name,Article_Title,See_Count From Article Where Article_Hid<>1 And IsPhoto=0 And DateDiff(day,Article_Time, getdate()) =0 Order By See_Count Desc,Article_ID Desc'
exec(@sql)
@tt=@pageSize*(@pageNumber-1)
Select Top @PageSize
TID,Topic,AddedMember,AddedDate,HitSum,ReplySum,LRMember,LRDate,ThemeID,Up
From Topics Where TID NOT IN
(Select Top '+cast(@pageSize*(@pageNumber-1) as varchar(20))+' TID From Topics
Where ThemeID=@tt Order By Up Desc,LRDate Desc,TID Desc)
AND ThemeID=themeid Order By Up Desc,LRDate Desc,TID Desc