MSSQL - Fix Error - There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

Watch this example on YouTube



There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

To fix it replace
  Insert Into TestTable (ID, Name) Values (1, 'aaa', 'bbb')
with  
  Insert Into TestTable (ID, Name) Values (1, 'aaa')