Insert Error: Column name or number of supplied values does not match table definition

SQL Server Error Message: Column name or number of supplied values does not match table definition

Error Message:

Server: Msg 213, Level 16, State 5, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

Causes:

This error occurs when doing an INSERT where the columns list is not specified and the values being inserted, either through the VALUES clause or through a SELECT subquery, are either more than or less than the columns in the table.

Need Additional Assistance?

Looking for a second opinion on a SQL Server error code? Get in touch with
Xynomix and we'll assess your issue and help to action a fix.

Contact Us



    On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.

    Testimonials

    Success Stories
    Testimonials

    Data Systems Manager – Media Industry

    “Xynomix investigated the performance bottlenecks that we were experiencing after updating our data warehouse application. After investigating the system, Xynomix concluded that the database server’s cache-hit rates and available memory were both low, which was impacting negatively on performance. The technician rectified this and we are now very happy with the function of the application.”

    Read More »
    Success Stories
    Testimonials

    Business Services – Director

    “We do not have the resources to employ full time DBAs. Xynomix give us the confidence to go out and win new business, knowing that we can deliver our services and our systems can cope.”

    Read More »