selectroominfo_config.sql

一个基本的酒店管理系统

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

GO

PRINT 'Creating Procedure SelectRoominfo_Config'
GO
CREATE Procedure SelectRoominfo_Config
	@rtid int
AS

/******************************************************************************
**		File: 当@rtid=0时为查询所有
**		Name: SelectRoominfo_Config
**		Desc: 
**
**		This template can be customized:
**              
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: 
**		Date: 
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
if(0=@rtid)
select * from RoomInfo_config_view 
else
select * from RoomInfo_config_view where rtid=@rtid
GO

GRANT EXEC ON SelectRoominfo_Config TO PUBLIC

GO