# Inserting Data

Add rows to a table with INSERT INTO, name the columns you fill, let identity columns number new rows, and respect the table's keys.

![Cheat sheet: Inserting Data](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/846948ba43394062b67fe24f75b1ff28.webp)

- Category: SQL
- Level: Apprentice
- Tags: DECLARE and SET, IDENTITY (t-sql), INSERT, NOT NULL Constraint, SCOPE_IDENTITY, sql, t-sql, VALUES Clause
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/modifying-data-in-t-sql-inserting-data-cheat-sheet