sql语句-创表那错了?

来源：百度知道 编辑：UC知道 时间：2024/06/23 04:10:32
CREATE TABLE [dbo].[DX_Forum_Chat](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UserFrom] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserFromID] [int] NULL,
[UserTo] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserToID] [int] NULL,
[ChatContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[Private] [int] NULL,
[ChatTime] [datetime] NULL,
CONSTRAINT [PK_DX_Forum_Chat] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE _ON [PRIMARY]
GO
服务器: 消息 170，级别 15，状态 1，行 13
第 13 行: '(' 附近有语法错误。

TEXTIMAGE _ON 改成 TEXTIMAGE_ON

CREATE TABLE [dbo].[DX_Forum_Chat](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UserFrom] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserFromID] [int] NULL,
[UserTo] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserToID] [int] NULL,
[ChatContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[Private] [int] NULL,
[ChatTime] [datetime] NULL,
CONSTRAINT [PK_DX_Forum_Chat] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

复制我的不会错

貌视这不是标准sql啊 怎么那么多的中括号？ 什么数据库说下

小不得，不过楼上的也是错的。