帮忙看看哪里错了

[opou]

/*
* Create Table News
* */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[News](
	[id] [nvarchar](32) NOT NULL,
	[visible] [bit] NOT NULL,
	[title] [nvarchar](256) NOT NULL,
	[date] [datetime] NOT NULL,
	[content] [nvarchar](4000) NULL,
	[imageUrl] [nvarchar](256) NULL,
	[imageAltText] [nvarchar](256) NULL,
	[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
服务器: 消息 170，级别 15，状态 1，行 15
第 15 行: '(' 附近有语法错误。

[叶子]

/*
* Create Table News
* */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[News](
    [id] [nvarchar](32) NOT NULL,
    [visible] [bit] NOT NULL,
    [title] [nvarchar](256) NOT NULL,
    [date] [datetime] NOT NULL,
    [content] [nvarchar](4000) NULL,
    [imageUrl] [nvarchar](256) NULL,
    [imageAltText] [nvarchar](256) NULL,
    [displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED 
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/*
Command(s) completed successfully.
*/

在我这运行没有问题。

[winter75]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[News](
    [id] [nvarchar](32) NOT NULL,
    [visible] [bit] NOT NULL,
    [title] [nvarchar](256) NOT NULL,
    [date] [datetime] NOT NULL,
    [content] [nvarchar](4000) NULL,
    [imageUrl] [nvarchar](256) NULL,
    [imageAltText] [nvarchar](256) NULL,
    [displayOrder] [int] NULL,

CONSTRAINT ID_PK PRIMARY KEY (ID)

)
END
GO

[opou]

[Quote=引用 4 楼 maco_wang 的回复:]
SQL code
/*
* Create Table News
* */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[News](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[title] [nvarchar](256) NOT NULL,
[date] [datetime] NOT NULL,
[content] [nvarchar]…
[/Quote]

我用的是SQL2000,这段代码按说是正确的啊，可是我怎么一直有错误呢？

[oswica]

问题是这个代码是sql2005生成的，不能在2000上用。

2000的系统表是 sysobjects ，05的是sys.objects，这个容易区分的。

[Zoezs]

索引冲突了吧？

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[News](
    [id] [nvarchar](32) NOT NULL,
    [visible] [bit] NOT NULL,
    [title] [nvarchar](256) NOT NULL,
    [date] [datetime] NOT NULL,
    [content] [nvarchar](4000) NULL,
    [imageUrl] [nvarchar](256) NULL,
    [imageAltText] [nvarchar](256) NULL,
    [displayOrder] [int] NULL,
) ON [PRIMARY]
END
GO

[claro]

命令已成功完成。