Syntax error converting the varchar value to a column of data type int

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?

Looking for a second opinion on a SQL Server error code? Get in touch with
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

    Testimonials

    IT Manager – Trade Union

    “Since 2003 Xynomix have provided support and consultancy for our Oracle and SQL Server databases. We’ve found their knowledge to be extensive and they’ve ensured that our databases run smoothly with very little downtime. The flexibility and creativity that Xynomix show when working with us enables us to meet budgets and hit our project timescales.”

    Read More »
    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.”

    Read More »