Inserting multiple rows in a single SQL Server query

SQL Server


Famous database from Microsoft. Skyvia requires the server to be available from Internet.

How to insert multiple rows WITHOUT repeating the “INSERT INTO ...” part of the statement

Query Text

use AdventureWorks2012;
INSERT INTO HumanResources.Department (Name, GroupName)
        ('Cleaning', 'Other'),
        ('Legal', 'Executive General and Administration')

Open Query