如何把2005的表原样导入2000中?? 用2005的生成sql脚本,在2000下报错,因为语法不同如果用导入程序,表的主键和列可否为null就没有了,表不完整,有什么方法 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 选择数据库,右键属性,“选项”页,“兼容级别”选择为“SQL Server 2000(80)”然后生成脚本即可。 奇怪,还是不行我在摘要里面选择表-〉编写脚本->create出来以下代码SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[bykai_a_xs01_t_xs01]( [ID] [int] IDENTITY(1,1) NOT NULL, [brand] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [area] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [dpnumber] [int] NULL, [dpnumber_ly] [int] NULL, [aim_price_tm] [decimal](12, 1) NULL, [sale_price] [decimal](12, 1) NULL, [sale_price_ntm] [decimal](12, 1) NULL, [aim_price_dcl] [int] NULL, [sale_price_ly] [decimal](12, 1) NULL, [grow] [int] NULL, [ddgrow] [int] NULL, [brand_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [StartDate] [datetime] NULL, [EndDate] [datetime] NULL, [InsertDate] [datetime] NULL, [a_cequence] [int] NULL, CONSTRAINT [PK_bykai_a_xs01_t_xs01] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]2000下不支持的 SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[bykai_a_xs01_t_xs01]([ID] [int] IDENTITY(1,1) NOT NULL,[brand] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,[area] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,[dpnumber] [int] NULL,[dpnumber_ly] [int] NULL,[aim_price_tm] [decimal](12, 1) NULL,[sale_price] [decimal](12, 1) NULL,[sale_price_ntm] [decimal](12, 1) NULL,[aim_price_dcl] [int] NULL,[sale_price_ly] [decimal](12, 1) NULL,[grow] [int] NULL,[ddgrow] [int] NULL,[brand_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,[StartDate] [datetime] NULL,[EndDate] [datetime] NULL,[InsertDate] [datetime] NULL,[a_cequence] [int] NULL, CONSTRAINT [PK_bykai_a_xs01_t_xs01] PRIMARY KEY CLUSTERED ([ID] ASC)ON [PRIMARY]) 如何把GETDATE()的格式转换成'2012-2-18' 格式 帮忙看看这个查询语句怎么写 Sql server 2000 导出到 oracle 10g ...出错。 一个比较难的SQL取数据 高手帮助,两个查询语句,很奇怪的问题,搞了我一天了,也没也来. SQL Server 2000 数据库文件被破坏怎样修复 一个变态的考勤难题(倒班+无上班、下班指示) 怎样让contains返回的结果照权重来排序 SQL高手请进 请各位兄弟帮忙,进者有分; 存储过程中调用存储过程--急!!!在线等 弱弱的问一个,关于两表相连
我在摘要里面选择表-〉编写脚本->create
出来以下代码SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[bykai_a_xs01_t_xs01](
[ID] [int] IDENTITY(1,1) NOT NULL,
[brand] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[area] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[dpnumber] [int] NULL,
[dpnumber_ly] [int] NULL,
[aim_price_tm] [decimal](12, 1) NULL,
[sale_price] [decimal](12, 1) NULL,
[sale_price_ntm] [decimal](12, 1) NULL,
[aim_price_dcl] [int] NULL,
[sale_price_ly] [decimal](12, 1) NULL,
[grow] [int] NULL,
[ddgrow] [int] NULL,
[brand_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[InsertDate] [datetime] NULL,
[a_cequence] [int] NULL,
CONSTRAINT [PK_bykai_a_xs01_t_xs01] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
2000下不支持的
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[bykai_a_xs01_t_xs01](
[ID] [int] IDENTITY(1,1) NOT NULL,
[brand] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[area] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[dpnumber] [int] NULL,
[dpnumber_ly] [int] NULL,
[aim_price_tm] [decimal](12, 1) NULL,
[sale_price] [decimal](12, 1) NULL,
[sale_price_ntm] [decimal](12, 1) NULL,
[aim_price_dcl] [int] NULL,
[sale_price_ly] [decimal](12, 1) NULL,
[grow] [int] NULL,
[ddgrow] [int] NULL,
[brand_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[InsertDate] [datetime] NULL,
[a_cequence] [int] NULL,
CONSTRAINT [PK_bykai_a_xs01_t_xs01] PRIMARY KEY CLUSTERED
(
[ID] ASC
)
ON [PRIMARY]
)