SQL 创建语句在自动增量附近的语法不正确

SQL create statement incorrect syntax near auto increment

提问by sharon Hwk

I created the following table, but I get an error;

我创建了下表，但出现错误；

Incorrect syntax near 'AUTO_INCREMENT'.

“AUTO_INCREMENT”附近的语法不正确。

SQL

SQL

CREATE TABLE [dbo].[MY_TABLE] (
    [ID] INT NOT NULL AUTO_INCREMENT,
    [NAME]          NVARCHAR (100) NULL,
    [SCHOOL]             NVARCHAR (100) NULL,
    PRIMARY KEY (ID)
);

i think i have done everything right. can someone help me out?

我想我已经做对了一切。有人可以帮我吗？

回答by Mahmoud Gamal

It is IDENTITYnot AUTO_INCREMENTin SQL Server.

它IDENTITY不在AUTO_INCREMENTSQL Server 中。

Try this instead:

试试这个：

CREATE TABLE [dbo].[MY_TABLE] (
    [ID] INT NOT NULL IDENTITY(1, 1),
    [NAME]          NVARCHAR (100) NULL,
    [SCHOOL]             NVARCHAR (100) NULL,
    PRIMARY KEY (ID)
);

回答by spajce

Its not AUTO_INCREMENT. Here the Demofrom sqlfiddle

它不是AUTO_INCREMENT。这里是来自 sqlfiddle的Demo