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.
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')
Enter your email address to subscribe to this blog and receive notifications of new posts by email.