selectisjacknewroom.sql

来自「一个基本的酒店管理系统」· SQL 代码 · 共 45 行

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Select_isJackFromNewRoom')
	BEGIN
		PRINT 'Dropping Procedure Select_isJackFromNewRoom'
		DROP  Procedure  Select_isJackFromNewRoom
	END

GO

PRINT 'Creating Procedure Select_isJackFromNewRoom'
GO
CREATE Procedure Select_isJackFromNewRoom
	/* Param List */
AS

/******************************************************************************
**		File: 
**		Name: Select_isJackFromNewRoom
**		Desc: 查询今日提醒的房间信息返回房间
**
**		This template can be customized:
**              
**		Return values:编号：Nrid   提醒时间：JackTime
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: 
**		Date: 
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
select  Nrid ,convert(varchar(20),DATEADD(day ,Ndays,Ndatetime)) as JackTime from newroom where (NisJack=1 and DATEDIFF(day,DATEADD(day ,Ndays,Ndatetime),getdate())=0)
GO

GRANT EXEC ON Select_isJackFromNewRoom TO PUBLIC

GO