YouTip

SQL Server Tutorial - Getting Started

📅 2026-06-12 | 📂 SQL Server

SQL Server Basics

CREATE TABLE users (
    id INT IDENTITY PRIMARY KEY,
    name NVARCHAR(100),
    email NVARCHAR(100)
);

INSERT INTO users (name, email) VALUES ("Alice", "a@b.com");
SELECT TOP 10 * FROM users ORDER BY name;

Summary

Microsoft SQL Server uses T-SQL dialect
IDENTITY for auto-increment