CabaretDBProject/Create Scripts/UpdateRoomTypeByTid.sql

（完整代码） 1KB 

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

GO

PRINT 'Creating Procedure UpdateRoomTypeByTid'
GO
CREATE Procedure UpdateRoomTypeByTid
	@tid int,
	@type varchar(20),
	@priceday float,
	@pricehour float,
	@istimeroom int,
	@setNum int
AS

/******************************************************************************
**		File: 
**		Name: UpdateRoomTypeByTid
**		Desc: 
**
**		This template can be customized:
**              
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: 
**		Date: 
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/

update typeroom set ttype=@type,pricebyday=@priceday,pricebyhour=@pricehour,istimeroom=@istimeroom,setnum=@setNum where Tid=@tid


GO

GRANT EXEC ON UpdateRoomTypeByTid TO PUBLIC

GO

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。