Microsoft SQL Server Cheat Sheet

-- Connect via sqlcmd-- sqlcmd -S localhost -U sa -P YourPasswordSELECT name FROM sys.databases;USE MyDb;GOSELECT TOP 10 * FROM Users;

CREATE TABLE Users (  Id INT IDENTITY(1,1) PRIMARY KEY,  Email NVARCHAR(255) NOT NULL UNIQUE,  CreatedAt DATETIME2 DEFAULT SYSUTCDATETIME());INSERT INTO Users (Email) VALUES ('a@b.com');MERGE INTO Users AS targetUSING (SELECT 1 AS Id, 'x@y.com' AS Email) AS srcON target.Id = src.IdWHEN MATCHED THEN UPDATE SET Email = src.EmailWHEN NOT MATCHED THEN INSERT (Email) VALUES (src.Email);

CREATE CLUSTERED INDEX IX_Users_Id ON Users(Id);CREATE NONCLUSTERED INDEX IX_Users_Email ON Users(Email);SET STATISTICS IO ON;SELECT * FROM Users WHERE Email = 'a@b.com';