Incorrect Syntax near ‘AUTO_INCREMENT’.
sql
CREATE TABLE [dbo].[MY_TABLE] ( [ID] INT NOT NULL AUTO_INCREMENT,[NAME] NVARCHAR (100) NULL,[SCHOOL] NVARCHAR (100) NULL,PRIMARY KEY (ID) );
我想我已经做好了一切.有人可以帮我吗?
IDENTITY
试试这个:
CREATE TABLE [dbo].[MY_TABLE] ( [ID] INT NOT NULL IDENTITY(1,1),PRIMARY KEY (ID) );