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 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.”
Network Administrator – Dragon LNG Ltd
“We recently installed a new application which ran on Oracle but was unsure how to correctly license the environment. As a result, we engaged with Xynomix to advise on how best to do so. Xynomix ran an Independent Oracle License Review, which gave us full visibility on our license compliance. They highlighted the restrictions around various license types, whilst also detailing how to avoid any pitfalls moving forward.”
