SQL Tutorial: INSERT

The INSERT statement is used to insert new records in a table

INSERT Syntax

INSERT INTO table_name(column1, column2, column3, ...)
VALUES(value1, value2, value3, ...);

We insert data into the category table in the Northwind database

insert into Categories(CategoryName, Description)
values(N'SQL Tutorial', 'SQL Tutorial for Beginners')

To view data you can select all records from the category table

select *from Categories