日期:2014-05-18  浏览次数:20522 次

大家帮忙看看下面的代码。报错
USE   [JobOnLineDB]
GO
SET   ANSI_NULLS   ON
GO
SET   QUOTED_IDENTIFIER   ON
GO
CREATE   TABLE   [dbo].[JobCategory](
[CategoryID]   [int]   IDENTITY(1,1)   NOT   NULL,
[CategoryTxt]   [nvarchar](50)   COLLATE   Chinese_PRC_CI_AS     NULL,
[CategoryMode]   [int]   NULL   CONSTRAINT   [DF_JobCategory_CategoryMode]   DEFAULT((0)),
[ParentID][int]   NULL,
CONSTRAINT   [PK_JobCategory_1]   PRIMARY   KEY   CLUSTERED
(
[CategoryID]   ASC
)
WITH(PAD_INDEX=OFF,IGNORE_DUP_KEY=OFF)ON   [PRIMARY]
)
GO
Server:   Msg   170,   Level   15,   State   1,   Line   10
Line   10:   Incorrect   syntax   near   '( '.
谢谢。是SQL2000

------解决方案--------------------
把WITH(PAD_INDEX=OFF,IGNORE_DUP_KEY=OFF)去掉就可以了