酒店管理系统 SET ANSI_NULLS ON<br>GO<br>SET

文件名称: 酒店管理系统

所属分类: Java

开发工具:

文件大小: 225kb

下载次数: 0

上传时间: 2008-06-28

提供者: Summit******

下载 (225kb)

不能下载？报告错误

详细说明： SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE DATABASE [royal]
GO
USE [royal]
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RoomInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[RoomInfo](
[RoomNo] [int] NOT NULL,
[FloorNo] [int] NOT NULL,
[Status] [varchar](100) NOT NULL,
[AssignedTo] [varchar](100) NOT NULL,
CONSTRAINT [PK_RoomInfo] PRIMARY KEY CLUSTERED
(
[RoomNo] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
INSERT INTO [RoomInfo] VALUES (1001,1,'Cleaned','Kim')
INSERT INTO [RoomInfo] VALUES (1002,1,'Cleaned','Adachi')
INSERT INTO [RoomInfo] VALUES (1003,1,'Not Cleaned','John')
INSERT INTO [RoomInfo] VALUES (1004,1,'Cleaned','Sue')
INSERT INTO [RoomInfo] VALUES (2001,2,'Cleaned','Joe')
INSERT INTO [RoomInfo] VALUES (2002,2,'Not Cleaned','Kerry')
INSERT INTO [RoomInfo] VALUES (2003,2,'Cleaned','Roy')
INSERT INTO [RoomInfo] VALUES (2004,2,'Cleaned','Carter')
INSERT INTO [RoomInfo] VALUES (3001,3,'Cleaned','Arnold')
INSERT INTO [RoomInfo] VALUES (3002,3,'Not Cleaned','Shane')
INSERT INTO [RoomInfo] VALUES (3003,3,'Cleaned','Kim')
INSERT INTO [RoomInfo] VALUES (3005,3,'Not Cleaned','Carter')
INSERT INTO [RoomInfo] VALUES (4001,4,'Cleaned','Shane')
INSERT INTO [RoomInfo] VALUES (4002,4,'Not Cleaned','Sherry')
INSERT INTO [RoomInfo] VALUES (4003,4,'Cleaned','Arnold')
INSERT INTO [RoomInfo] VALUES (4004,4,'Not Cleaned','John')

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[loginuser]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[loginuser](
[Username] [varchar](50) NULL,
[Password] [varchar](50) NULL
) ON [PRIMARY]
END
INSERT INTO [loginuser] VALUES ('manager','password')
INSERT INTO [loginuser] VALUES ('assistant','password')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Employees]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Employees](
[Name] [varchar](50) NULL,
[Designation] [varchar](50) NULL,
[Address] [varchar](50) NULL,
[Telephone] [varchar](50) NULL,
[Fax] [varchar](50) NULL,
[EMail] [varchar](50) NULL,
[ID] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
END
INSERT INTO [Employees] VALUES ('Kim','Cleaning Staff','California','0015688489','0015688489','kim@royal.com')
INSERT INTO [Employees] VALUES ('Adachi','Cleaning Staff','California','0015633443','0015633443','adachi@royal.com')
INSERT INTO [Employees] VALUES ('Roy','Cleaning Staff','California','0015623452','0015623452','roy@royal.com')
INSERT INTO [Employees] VALUES ('Carter','Cleaning Staff','California','0015621356','0015621356','carter@royal.com')
INSERT INTO [Employees] VALUES ('Sherry','Cleaning Staff','California','0015688960','0015688960','sherry@royal.com')
INSERT INTO [Employees] VALUES ('Kerry','Cleaning Staff','California','0015665740','0015665740','kerry@royal.com')
INSERT INTO [Employees] VALUES ('Shane','Cleaning Staff','California','0015644988','0015644988','shane@royal.com')
INSERT INTO [Employees] VALUES ('John','Cleaning Staff','California','0015600968','0015600968','john@royal.com')
INSERT INTO [Employees] VALUES ('Sue','Cleaning Staff','California','001564539','001564539','sue@royal.com')
INSERT INTO [Employees] VALUES ('Arnold','Cleaning Staff','California','0015634690','0015634690','arnold@royal.com')
INSERT INTO [Employees] VALUES ('Ann','Manager','California','0015643790','0015643790','ann@royal.com')
INSERT INTO [Employees] VALUES ('Swan','Assistant','California','0015622486','0015622486','swan@royal.com')
INSERT INTO [Employees] VALUES ('Joy','Assistant','California','0015644667','0015644667','joy@royal.com') ...展开收缩