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
Business Operations Manager – Manufacturing Industry
“In the manufacturing sector, we need flexibility and immediate assistance when things go wrong. Xynomix have achieved this brilliantly, and make sure that at least one DBA is available when we call with a problem at any time of the day or night.”
IT Infrastructure Engineer – Welcome Finance
“A recent project required the redaction of a large volume of data against a strict deadline. Xynomix were able to take a copy of the data and carry out the work all whilst maintaining the meaning of the data for review by other parties, within the deadline. The technical expertise and swift proactive support of the Xynomix team has ensured that even during a challenging period for Welcome Finance, we are able to ensure that our data and database performance is consistent which, in turn enables us to focus on additional projects.”
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.”
Lead Database Administrator – Manufacturing Industry
“We have been running Microsoft SQL Server for around two years now and the systems have been supported by Xynomix. Their SQL DBAs are competent and very customer-facing.”