CREATE TABLE Persons ( Personid int IDENTITY(1,1) PRIMARY KEY, LastName varchar(255) NOT NULL, FirstName varchar(255), Age int );

https://www.w3schools.com/SQl/sql_autoincrement.asp

with unique mssql field CREATE TABLE zz_customers ( id INT IDENTITY(1,1) PRIMARY KEY, lkh_short_customer_name VARCHAR(255) DEFAULT '' NOT NULL UNIQUE, userdb VARCHAR(255) DEFAULT '' NOT NULL UNIQUE, invoice INT DEFAULT 0 NOT NULL, orders INT DEFAULT 0 NOT NULL, hash VARCHAR(8) DEFAULT '' NOT NULL ) 03.04.19 CREATE TABLE zz_groups ( id INT IDENTITY(1,1) PRIMARY KEY, group_name VARCHAR(255) DEFAULT '' NOT NULL UNIQUE, ) 03.04.19

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024