一个关于SQL语句的问题。

[souhay]

在创建表的语句中。
CREATE TABLE [dbo].[BaseApplication] (
[FileContent] [image] NULL ,
[ApID] [int] IDENTITY (1, 1) NOT NULL ,
[ProjID] [int] NOT NULL ,
[ApName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
这名不正正确。
[ApName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
提示是Incorrect syntax near 'COLLATE'.
请问是什么原因。

[karma]

try

[ApName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
==>
[ApName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL

[souhay]

这是什么意思啊？

[karma]

you have an extra "," at the end of
[ApName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
^^^^^^

[souhay]

现在的问题是不是最后一条的问题，下面有一段语句我把他给剪掉了。
有“，”号是没有错的。

[karma]

after "," is removed, it runs fine on SQL Server 2000

[souhay]

一定要在 SQL Server 2000 上吗？

[karma]

i do not have other database servers at hand

[tripofdream]

sql7.0(e版)的create table语法中没有COLLATE关键字.