Working with Tables: CREATE, INSERT, SELECT

Intermediate Updated March 20, 2025

🧱 Working with Tables: CREATE, INSERT, SELECT

Creating and manipulating tables is central to SQL Server development.

-- Create a table for Books
CREATE TABLE Books (
    BookID INT IDENTITY(1,1) PRIMARY KEY,
    Title NVARCHAR(255),
    Author NVARCHAR(100),
    PublishedYear INT
);

-- Add a book
INSERT INTO Books (Title, Author, PublishedYear)
VALUES ('1984', 'George Orwell', 1949);

-- Retrieve all books
SELECT * FROM Books;