| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 706 人关注过本帖
标题:原题重提
只看楼主 加入收藏
ichdish
Rank: 1
等 级:新手上路
帖 子:7
专家分:0
注 册:2008-12-3
收藏
 问题点数:0 回复次数:5 
原题重提
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[airlineInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[airlineInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[customerInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[customerInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[customerType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[customerType]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[planeInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[planeInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[serviceInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[serviceInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ticketInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ticketInfo]
GO

CREATE TABLE [dbo].[airlineInfo] (
    [airlineNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [departCity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [arrivalCity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [departDate] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [departTime] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [arrivalTime] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [planeNO] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
    [commonPrice] [numeric](18, 2) NULL ,
    [commercialPrice] [numeric](18, 2) NULL ,
    [firstPrice] [numeric](18, 2) NULL ,
    [airlineMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[customerInfo] (
    [customerNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [customerName] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [customerSex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
    [customerID] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
    [customerTele] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [customerType] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
    [customerMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[customerType] (
    [ctypeNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [ctypeName] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [discount] [numeric](2, 0) NULL ,
    [ctypeMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[planeInfo] (
    [planeNO] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [planeType] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [buyDate] [datetime] NULL ,
    [serveDate] [datetime] NULL ,
    [isCommon] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [isCommercial] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [isFirst] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [planeMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[serviceInfo] (
    [serviceNO] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [serviceName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [noPresent] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
    [noNewsPaper] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
    [noDrink] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
    [noFood] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
    [noMovie] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
    [canChange] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
    [canCancel] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
    [canDiscount] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
    [serviceMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[ticketInfo] (
    [ticketNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [customerNO] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
    [customerName] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [customerType] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
    [discount] [numeric](18, 0) NULL ,
    [airlineNO] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
    [departCity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [arrivalCity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [ticketDate] [datetime] NULL ,
    [serviceType] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [ticketPrice] [numeric](18, 2) NULL ,
    [ticketSum] [numeric](18, 2) NULL ,
    [ticketMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
搜索更多相关主题的帖子: SQL函数 
2008-12-05 12:09
jxyga111
Rank: 8Rank: 8
来 自:中華人民共和國
等 级:贵宾
威 望:33
帖 子:6015
专家分:895
注 册:2008-3-21
收藏
得分:0 
非常不明白你這是什么意思

烈焰照耀世界,斌凍凍千萬裏
2008-12-05 13:34
三断笛
Rank: 10Rank: 10Rank: 10
等 级:贵宾
威 望:31
帖 子:1621
专家分:1617
注 册:2007-5-24
收藏
得分:0 
把你的数据库脚本导出来提什么问题?
2008-12-05 16:15
wyfandy
Rank: 1
来 自:深圳
等 级:新手上路
帖 子:376
专家分:0
注 册:2006-12-11
收藏
得分:0 
怎么没有说出是什么问题咧?

不论什么事,只要认准了一个目标,然后朝之不懈地努力,就一定实现。编程爱好者QQ群:21318556
2008-12-05 16:23
三断笛
Rank: 10Rank: 10Rank: 10
等 级:贵宾
威 望:31
帖 子:1621
专家分:1617
注 册:2007-5-24
收藏
得分:0 
当垃圾帖删掉
2008-12-05 16:25
风吹过b
Rank: 20Rank: 20Rank: 20Rank: 20Rank: 20
等 级:贵宾
威 望:364
帖 子:4941
专家分:30047
注 册:2008-10-15
收藏
得分:0 
SQL SERVER 脚本。
不需要发在这里吧。

授人于鱼,不如授人于渔
早已停用QQ了
2008-12-05 17:04
快速回复:原题重提
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.017489 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved