Skip to the content.

When performing a multi-row insert using values, the number of values in each row must match.

Bad:

insert SomeTable (Name, Value)
values ('abc', 42), ('def', 63, 'ghi')

Good:

insert SomeTable (Name, Value, Description)
values ('abc', 42, ''), ('def', 63, 'ghi')