UC知道sql2005的数据库升级脚本如何才能用到sql2000上
来源：百度知道 编辑：UC知道 时间：2024/09/21 01:47:55
我写了一个数据库的更新脚本,,我用的是SQL2005的,所以在SQL2005上运行一点都没有问题,可是一到SQL2000上运行时,就提示出现很多问题..对于这两个版本的兼容问题我不是很清楚,,请大家帮忙看看,这个兼容问题要注意哪些?
谢谢
不好意思,这个不是很方便...
部分
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[JifenRoleExt]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[JifenRoleExt](
[ID] [int] NOT NULL,
[JifenRatio] [varchar](20) NULL,
CONSTRAINT [PK_JifenRoleExt] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderForm]') AND type in (N'U'))
BEGIN
alter TABLE [dbo].[OrderForm]
add [Jifen] [int
谢谢
不好意思,这个不是很方便...
部分
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[JifenRoleExt]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[JifenRoleExt](
[ID] [int] NOT NULL,
[JifenRatio] [varchar](20) NULL,
CONSTRAINT [PK_JifenRoleExt] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderForm]') AND type in (N'U'))
BEGIN
alter TABLE [dbo].[OrderForm]
add [Jifen] [int
SQL2000几年没用了，楼主按以下方式改就行了
建表改为
CREATE TABLE [dbo].[JifenRoleExt](
[ID] [int] NOT NULL,
[JifenRatio] [varchar](20) NULL,
CONSTRAINT [PK_JifenRoleExt] PRIMARY KEY CLUSTERED
(
[ID] --去掉asc
)
--去掉with
) ON [PRIMARY]
sys.objects--改为sysobjects--不用"."
SQL2000的查询分析器对于运行脚本来说，跟2005差别不大
你的更新脚本有多复杂？秀一下