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 vote99 views1 answer
Sql select lowest value row
SQL
0 vote166 views1 answer
Bigrock database connection string
SQL
0 vote121 views1 answer
To_date sql
SQL
0 vote111 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
8 votes111 views3 answers
Connect python to mysql
SQL
1 vote112 views1 answer
Sql server datetime vs datetime2
SQL
7 votes100 views3 answers
How ot change name of column mysql
SQL
1 vote116 views1 answer
Mysql f# examples
SQL
0 vote128 views1 answer
Sql field equals multiple values
SQL
0 vote110 views1 answer
How to add more columns to a table in mysql
SQL