Programming Logic and Code: March 2020

Monday, March 30, 2020

SQL Server Error

Error-1

When we try to insert a new row but the no of column specified and values passed is greater then we used to get this error.

The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.

Error Msg 121
Error Level 15,
Error State 1,
Error Line 91

"The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns."

Subscribe to: Posts (Atom)