SQL Server Error Msg 110 – There are fewer columns in the INSERT statement than values specified in the VALUES clause

SQL Server Error Message

Msg 110, Level 15, State 1, Line 1
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.

Reason for the Error

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 where the the number of values (parameters) specified in the VALUES clause is more than 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)
VALUES (1,'SENTHIL','KUMAR')

You can see from the above example that the INSERT INTO contains 2 columns (id,FirstName) whereas the VALUES contains 3 parameters.

Solution

The fix to this error is very simple. Just make sure that the number of 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')