CabaretDBProject/Create Scripts/RoomInfo_config_view.sql

（完整代码） 1KB 

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = 'RoomInfo_config_view')
	BEGIN
		PRINT 'Dropping View RoomInfo_config_view'
		DROP  View RoomInfo_config_view
	END
GO

/******************************************************************************
**		File: 
**		Name: RoomInfo_config_view
**		Desc: 
**
**		This template can be customized:
**              
**
**		Auth: 
**		Date: 
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/

PRINT 'Creating View RoomInfo_config_view'
GO
CREATE View RoomInfo_config_view
as

select rid,(select ttype from typeroom where 
tid=rtid) as ttype,(select statetype from roomstate
where stateid=rstateid)as statetype,ingroup,roomtel,locknum,rtid from roominfo


GO


GRANT SELECT ON RoomInfo_config_view TO PUBLIC

GO

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

AI 解读

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

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