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

/* */

/* Author: bigeagle@163.net */

/* */

/* Date: 2000/4/17 */

/* */

/* History: */

/* */

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

if exists(select * from sysobjects where id = object_id('up_GetPostedForumInfo'))

drop proc up_GetPostedForumInfo

go

create proc up_GetPostedForumInfo @a_intForumID int

as

declare @intTopicCount int

declare @intRootTopicCount int

set nocount on

if not exists(select * from Forum where id=@a_intForumID) return 0

select @intTopicCount = count(*) from bbs where forumid = @a_intForumID and posted=1

select * , 'TopicCount'=@intTopicCount , 'RootTopicCount' = @intTopicCount

from Forum where id = @a_intForumID

set nocount off

go