我写了一个数据库的更新脚本,,我用的是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] NULL,
[UsedJifen] [int] NULL,
[UsedJifenMoney] [money] NULL
END
|
