cs_weblog_postsbymonth.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_PostsByMonth]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_weblog_PostsByMonth]
GO


CREATE proc [dbo].cs_weblog_PostsByMonth
(
	@SectionID int,
	@Year int,
	@Month int
)
as

SET Transaction Isolation Level Read UNCOMMITTED


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




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

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