shaolin.master.dp2

1:首先要导入hotel数据

/****** Object:  Table [dbo].[book]    Script Date: 2007-7-4 21:52:28 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[book]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[book]
GO

/****** Object:  Table [dbo].[book1]    Script Date: 2007-7-4 21:52:28 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[book1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[book1]
GO

/****** Object:  Table [dbo].[borrow]    Script Date: 2007-7-4 21:52:28 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[borrow]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[borrow]
GO

/****** Object:  Table [dbo].[reader]    Script Date: 2007-7-4 21:52:28 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[reader]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[reader]
GO