Inserting multiple rows in a single SQL query

Question

I have a set of  multiple values to insert in a table at once, like 4 rows. My table has three columns: Name, EmployeeId and Salary.

INSERT INTO Table VALUES ("Aman", 112, "30000");
INSERT INTO Table VALUES ("Ajay", 113, "30000");
INSERT INTO Table VALUES ("Akshay", 114, "40000");
INSERT INTO Table VALUES ("Abhishek", 115, "50000");

How to insert all the four rows in one single SQL statement?

Answer 1

In SQL Server 2008, multiple rows can be inserted using only a single SQL INSERT statement.

INSERT INTO MyTable ( Column1, Column2 ) VALUES
( Value1, Value2 ), ( Value1, Value2 )

For example:

INSERT INTO MyTable
  ( Column1, Column2, Column3 )
VALUES
  ('Aman', 112, '30000'), 
  ('Ajay', 113, '30000'), 
  ('Akshay', 114, '40000'),
  ('Abhishek', 115, '50000');