Hi,

When I create an identity column using the GENERATED ALWAYS AS IDENTITY statement and I try to INSERT or MERGE data into that table I keep getting the following error message:

Cannot write to 'table', not enough data columns; target table has x column(s) but the inserted data has x-1 column(s)

Shouldn't this work?