短信按时查看

USE [GameSms]

GO

/****** 对象: StoredProcedure [dbo].[draw] 脚本日期: 02/01/2007 14:22:53 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[draw]

@month int=NUll,

@day int =NULL

as

 
 

set @month = isnull(@month,(datename(dd,getdate())))

set @day = isnull(@day,(datename(dd,getdate())))

 
 

SELECT cast(DATENAME(hh, [wtime]) as int) AS E1, COUNT(1) AS E2 FROM smsin where DATENAME(dd, [wtime]) = @day and DATENAME(month, [wtime])=@month GROUP BY DATENAME(hh, [wtime]) order by E1

 
 

Return