SQLServer 2016.

sqlserver.md

SQLServer 2016

A few CRUD operations and SQL statements for SQL Server 2016.

#Drop DB

USE master ;  
GO  
DROP DATABASE MoviesDB ;  
GO  

# Create a new table and increment the ID.

CREATE TABLE Persons (
    Id int not null identity(1, 1) primary key,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);