Sql auto_increment syntax

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

Source: stackoverflow.com

Similar codes

0 vote134 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
5 votes131 views1 answer
Mysql where one year ago
SQL
-1 vote135 views1 answer
MYSQL stored procedure select from
SQL
5 votes203 views1 answer
Oracle asynchronous procedure
SQL
28 votes125 views6 answers
Sql update
SQL
2 votes135 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote131 views1 answer
How to connect to mysql in ef 6
SQL
0 vote127 views1 answer
Sql server remove enter from string
SQL
0 vote121 views2 answers
Sqlite unique
SQL
0 vote123 views1 answer
What alter does in db
SQL