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
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 Manager – Manufacturing Industry
“A good on-site DBA team, optimised database systems and 24×7 Oracle Support from Xynomix mean that not much goes wrong for us. We are confident enough to make promises of excellent availability to our clients and employees, and they always get it.”
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.”
