cs_weblog_postsbymonthlist.prc

community server 源码

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cs_weblog_PostsByMonthList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_weblog_PostsByMonthList]
GO


CREATE proc [dbo].cs_weblog_PostsByMonthList
(
	@SectionID int
)
as

SET Transaction Isolation Level Read UNCOMMITTED

Select Month(p.UserTime) as [Month], Year(p.UserTime) as [Year], 1 as Day, Count(*) as [Count] 
From cs_Posts p
where p.SectionID = @SectionID and p.IsApproved = 1 and p.ApplicationPostType = 1 and p.PostDate <= getdate()
Group by Year(p.UserTime), Month(p.UserTime) order by [Year] desc, [Month] desc




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

grant execute on [dbo].[cs_weblog_PostsByMonthList] to public
go