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
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.”
Enterprise Architect – North Yorkshire County Council
“Xynomix worked with us on our recent Oracle License Review and provided us with valuable independent and confidential advice to help us through what can be a confusing and complex process. They provided useful expert knowledge on Oracle Licensing policy and also suggested how any gaps could be most effectively licensed. I would certainly recommend working with Xynomix on any future Oracle License Review.”
Royal Borough of Windsor and Maidenhead
“Xynomix were very knowledgeable and had a team of dedicated technical and commercial staff who knew Oracle extremely well”
