INSERT INTO Table (Name, Location) SELECT 'Name1', 'Location1' UNION ALL SELECT 'Name2', 'Location2' UNION ALL SELECT 'Name3', 'Location3'