Javatpoint Logo
Javatpoint Logo

SQL Server Insert Data

In SQL Server database, INSERT statement is used to insert a single record or multiple records into a table.

Syntax:

Example:

Insert some records in "STUDENT" table:

You can directly use the above command in a New Query or follow the management studio screenshots given below:

SQL server insert data 1 SQL server insert data 2

View Inserted Data:

SQL server insert data 3

Output:

SQL server insert data 4

You can see that all three records are inserted now in the "Student" table.






Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA