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?
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
IT Manager – Further Education
“The optimisation, support and management of our Oracle database arrangement by Xynomix have increased the efficiency of the Oracle database and reduced the total running cost, whilst at the same time allowing us to provide a better service for staff and student end-users.”
ICT Group Manager – Southend-on-sea Borough Council
“We chose Xynomix from the multiple providers approached for our support requirement for a number of reasons. Initially we were impressed with their responsiveness and deep technical knowledge of both Oracle and Microsoft SQL Server databases. Their flexibility in providing mentoring to our on-site team meant increased cost efficiency against the already competitive annual costs and consultancy rates. We’re fully confident in their understanding of our needs and see them as an extension of our own team.”
