How to Insert Data in SQL Server
Last updated July 25, 2026 · By the SaturnSQL team
Use INSERT INTO ... VALUES with one or more row tuples (up to 1000 per statement), or INSERT ... SELECT to copy query results. The OUTPUT clause returns the inserted rows, including IDENTITY values.
INSERT INTO orders (customer_id, amount)
VALUES (101, 42.50), (102, 17.00), (103, 99.95);Insert from a query
INSERT INTO orders_archive (id, customer_id, amount)
SELECT id, customer_id, amount
FROM orders
WHERE created_at < '2025-01-01';Return the inserted rows with OUTPUT
INSERT INTO orders (customer_id, amount)
OUTPUT INSERTED.id, INSERTED.customer_id
VALUES (104, 25.00);Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free