c# - 查询在 SQL Server 2005 中有效，但在 SQL Server 2000 中出现语法错误

Question

我正在尝试执行此查询，但当它完全适用于 SQL Server 2005 并且表已经存在并且正在尝试在不同的服务器上创建新表时出现语法错误，

USE [myDataBase]
GO

CREATE TABLE [dbo].[myTable]
(
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [Tittle] [varchar](1024) NOT NULL,
    [Description] [varchar](8000) NOT NULL,
    [Table2ID] [int] NOT NULL,
    [Table3ID] [int] NOT NULL,
 CONSTRAINT [PK_myTable] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)



WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]

GO

错误

Msg 170, Level 15, State 1, Line 16 Line 16: Incorrect syntax near '('.

在上面的例子中，第 16 行是空的，我很困惑。

Answer 1

SQL Server 2000 中的

WITH 只允许设置 FillFactor。请参阅文档:

http://msdn.microsoft.com/en-us/library/aa258255%28v=sql.80%29.aspx

从 WITH 子句中删除其他选项。