一下是Sql Server2005建表以后导出的脚本,如何把他改成2000的脚本语句,能够在查询分析器里直接执行
CREATE TABLE [dbo].[quanxian](
[username] [nvarchar](8) COLLATE Chinese_PRC_CI_AS NOT NULL,
[pwd] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[rq] [datetime] NULL,
[usergl] [bit] NULL,
[databak] [bit] NULL,
[datarestore] [bit] NULL,
[datasort] [bit] NULL,
[gsdangan] [bit] NULL,
[renyuangl] [bit] NULL,
[cardail] [bit] NULL,
[cargh] [bit] NULL,
[zhengjiangl] [bit] NULL,
[qiyongk] [bit] NULL,
[zhoujiank] [bit] NULL,
[caijik] [bit] NULL,
[iczc] [bit] NULL,
[iczx] [bit] NULL,
[icsb] [bit] NULL,
[datacaiji] [bit] NULL,
[caijirecordsee] [bit] NULL,
[dailkcsee] [bit] NULL,
[sumsee] [bit] NULL,
[yingyunefx] [bit] NULL,
[yingyunlfx] [bit] NULL,
[shoufei] [bit] NULL,
[piaojugl] [bit] NULL,
[baoxiangl] [bit] NULL,
[qyout] [bit] NULL,
[tousu] [bit] NULL,
[jichaka] [bit] NULL,
[rejichaka] [bit] NULL,
[jsy] [bit] NULL,
CONSTRAINT [PK_quanxian] PRIMARY KEY CLUSTERED
(
[username] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[quanxian](
[username] [nvarchar](8) COLLATE Chinese_PRC_CI_AS NOT NULL,
[pwd] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[rq] [datetime] NULL,
[usergl] [bit] NULL,
[databak] [bit] NULL,
[datarestore] [bit] NULL,
[datasort] [bit] NULL,
[gsdangan] [bit] NULL,
[renyuangl] [bit] NULL,
[cardail] [bit] NULL,
[cargh] [bit] NULL,
[zhengjiangl] [bit] NULL,
[qiyongk] [bit] NULL,
[zhoujiank] [bit] NULL,
[caijik] [bit] NULL,
[iczc] [bit] NULL,
[iczx] [bit] NULL,
[icsb] [bit] NULL,
[datacaiji] [bit] NULL,
[caijirecordsee] [bit] NULL,
[dailkcsee] [bit] NULL,
[sumsee] [bit] NULL,
[yingyunefx] [bit] NULL,
[yingyunlfx] [bit] NULL,
[shoufei] [bit] NULL,
[piaojugl] [bit] NULL,
[baoxiangl] [bit] NULL,
[qyout] [bit] NULL,
[tousu] [bit] NULL,
[jichaka] [bit] NULL,
[rejichaka] [bit] NULL,
[jsy] [bit] NULL,
CONSTRAINT [PK_quanxian] PRIMARY KEY CLUSTERED
(
[username] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
[username] [nvarchar](8) PRIMARY KEY,
[pwd] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[rq] [datetime] NULL,
[usergl] [bit] NULL,
[databak] [bit] NULL,
[datarestore] [bit] NULL,
[datasort] [bit] NULL,
[gsdangan] [bit] NULL,
[renyuangl] [bit] NULL,
[cardail] [bit] NULL,
[cargh] [bit] NULL,
[zhengjiangl] [bit] NULL,
[qiyongk] [bit] NULL,
[zhoujiank] [bit] NULL,
[caijik] [bit] NULL,
[iczc] [bit] NULL,
[iczx] [bit] NULL,
[icsb] [bit] NULL,
[datacaiji] [bit] NULL,
[caijirecordsee] [bit] NULL,
[dailkcsee] [bit] NULL,
[sumsee] [bit] NULL,
[yingyunefx] [bit] NULL,
[yingyunlfx] [bit] NULL,
[shoufei] [bit] NULL,
[piaojugl] [bit] NULL,
[baoxiangl] [bit] NULL,
[qyout] [bit] NULL,
[tousu] [bit] NULL,
[jichaka] [bit] NULL,
[rejichaka] [bit] NULL,
[jsy] [bit] NULL
)
[username] [nvarchar](8) COLLATE Chinese_PRC_CI_AS NOT NULL,
[pwd] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[rq] [datetime] NULL,
[usergl] [bit] NULL,
[databak] [bit] NULL,
[datarestore] [bit] NULL,
[datasort] [bit] NULL,
[gsdangan] [bit] NULL,
[renyuangl] [bit] NULL,
[cardail] [bit] NULL,
[cargh] [bit] NULL,
[zhengjiangl] [bit] NULL,
[qiyongk] [bit] NULL,
[zhoujiank] [bit] NULL,
[caijik] [bit] NULL,
[iczc] [bit] NULL,
[iczx] [bit] NULL,
[icsb] [bit] NULL,
[datacaiji] [bit] NULL,
[caijirecordsee] [bit] NULL,
[dailkcsee] [bit] NULL,
[sumsee] [bit] NULL,
[yingyunefx] [bit] NULL,
[yingyunlfx] [bit] NULL,
[shoufei] [bit] NULL,
[piaojugl] [bit] NULL,
[baoxiangl] [bit] NULL,
[qyout] [bit] NULL,
[tousu] [bit] NULL,
[jichaka] [bit] NULL,
[rejichaka] [bit] NULL,
[jsy] [bit] NULL,
CONSTRAINT [PK_quanxian] PRIMARY KEY CLUSTERED ([username] ASC )
)
[username] [nvarchar](8) COLLATE Chinese_PRC_CI_AS NOT NULL,
[pwd] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[rq] [datetime] NULL,
[usergl] [bit] NULL,
[databak] [bit] NULL,
[datarestore] [bit] NULL,
[datasort] [bit] NULL,
[gsdangan] [bit] NULL,
[renyuangl] [bit] NULL,
[cardail] [bit] NULL,
[cargh] [bit] NULL,
[zhengjiangl] [bit] NULL,
[qiyongk] [bit] NULL,
[zhoujiank] [bit] NULL,
[caijik] [bit] NULL,
[iczc] [bit] NULL,
[iczx] [bit] NULL,
[icsb] [bit] NULL,
[datacaiji] [bit] NULL,
[caijirecordsee] [bit] NULL,
[dailkcsee] [bit] NULL,
[sumsee] [bit] NULL,
[yingyunefx] [bit] NULL,
[yingyunlfx] [bit] NULL,
[shoufei] [bit] NULL,
[piaojugl] [bit] NULL,
[baoxiangl] [bit] NULL,
[qyout] [bit] NULL,
[tousu] [bit] NULL,
[jichaka] [bit] NULL,
[rejichaka] [bit] NULL,
[jsy] [bit] NULL,
CONSTRAINT [PK_quanxian] PRIMARY KEY CLUSTERED ([username] ASC )
)