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