bbs的数据结构和存储过程（三）_ASP实例

return (-1)

/*求开始rootID*/

set @intRowCount = (@a_intPageNo - 1) * @a_intPageSize + 1

/*限制条数*/

set rowcount @intRowCount

select @intBeginID = rootid from bbs where posted=1 and forumid=@a_intForumID

order by id desc

/*结束rootID*/

set @intRowCount = @a_intPageNo * @a_intPageSize

/*限制条数*/

set rowcount @intRowCount

select @intEndID = rootid from bbs where posted=1 and forumid=@a_intForumID

order by id desc

/*恢复系统变量*/

set rowcount 0

set nocount off

select a.id , a.layer , a.forumid , a.subject , a.faceid , a.hits , a.time , a.UserID , a.fatherid , a.rootid ,

'Bytes' = datalength(a.content) , b.UserName , b.Email , b.HomePage , b.Signature , b.Point

from bbs as a join BBSUser as b on a.UserID = b.ID

where posted=1 and Forumid=@a_intForumID and a.rootid between @intEndID and @intBeginID

order by a.rootid desc , a.ordernum desc

return(@@rowcount)

--select @@rowcount

go

select id , rootid , fatherid , forumid , posted from bbs

up_getpostedtopiclist 3 ,1 , 20

/*************************************************************************/

/* */

/* procedure : up_GetTopic */

/* */

/* Description: 取贴子 */

/* */

/* Parameters: @a_intTopicID : 贴子id */

/* */

/* Use table: bbs */

/* */

/* Author: bigeagle@163.net */