SQL Server Error Message: Syntax error converting the varchar value to a column of data type int
Error Message:
Server: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value to a column of data type int.
Causes:
There are many ways this error may be encountered but the common reason is that you are trying to convert, either implicitly or explicitly, a varchar value to an int data type and the varchar value cannot be converted to an int data type. You may have a varchar column that may have integer values on most records but where some have non-integer values.
One other common reason why this is encountered is when creating a dynamic SQL statement and the query involves combining a varchar variable with an integer variable.
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
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.”
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.”
Group IT Manager – Manufacturing Industry
“Being able to trust a supplier is the goal of any relationship, and that’s exactly what we’ve achieved with Xynomix.”
