In SQL Server 2008, multiple rows can be inserted using a single SQL INSERT statement.
Are you interested in learning SQl from scratch! Have a look at this interesting video on SQL provided by Intellipaat:
INSERT INTO Table_Name(Col_Name)VALUES(Value_Name)
If you want to insert into a single table, then you can write the code like this:
INSERT INTO TableA (Col_First, Col_Last)
VALUES (‘James’, ‘Jonas’), (‘Jack’, ‘Jonas’), (‘Robert’, ‘Jonas’);