SQL Server Error Msg 109 – There are more columns in the INSERT statement than values specified in the VALUES clause.

SQL Server Error Message

Msg 109, Level 15, State 1, Line 1
There are more 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.

Reason for the Error

The error message is self-descriptive. You’ll see this error message when you are doing an INSERT operation to a table using INSERT TO.. VALUES statement and there is a mismatch (more columns) with the number of values (parameters) specified in the VALUES clause and the number of columns specified in to the INSERT TO.

For example, the below query results with the SQL Error Message Msg 109

INSERT INTO Students (Id,FirstName,LastName)
VALUES (1,'SENTHIL')
SQL Server Error Msg 109 - There are more columns in the INSERT statement than values specified in the VALUES clause.

Solution

The fix to this error is very simple. Just make sure that the number if values specified in the VALUES clause matches with the number of parameters in the INSERT INTO. The below query will work fine.

INSERT INTO Students (Id,FirstName,LastName)
VALUES (1,'SENTHIL','KUMAR')
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.