![]() ![]() SELECT statement, there are 3 columns specified in the SELECT clause but only 2 columns are specified in the INSERT INTO clause. The number of SELECT values must match the number of INSERT columns.Īs can be seen from the INSERT INTO. The select list for the INSERT statement contains more items than the insert list. To illustrate, the following INSERT statement will generate the error: INSERT INTO. ![]() The number of SELECT valuesĪs the error message describes, this error occurs when doing an INSERT to a table using the INSERT INTO … SELECT FROM format and the number of columns specified in the SELECT clause is more than the number of columns specified in the INSERT clause. The select list for the INSERT statement contains more The number of SELECT values must match the number of INSERT columns.Įrror Message Server: Msg 121, Level 15, State 1, Line 1 SQL Server Error Messages - Msg 121 - 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. Home > SQL Server Error Messages > Msg 121 - The select list for the INSERT statement contains more items than the insert list. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |