Home » convert varchar value to data type int in sql server

convert varchar value to data type int in sql server

sql server DBA 999

SQL Server Error : 245, Severity: 16. Conversion failed when converting the %l

SQL Server Error : 245 Details

SQL Server Error: 245 Severity: 16 Event Logged or not: No Description: Conversion failed when converting the %ls value ‘%.*ls’ to data type %ls. Severity 16 Description: Indicates general errors that can be corrected by the user.

SQL SERVER – Error: Msg 245 – Conversion failed when converting the varchar value ‘AllisWell’ to data type int

Solution for Resolving SQL Server Error 245

It’s critical that all return values be of the same data type when converting the data type. We’d wind up with conversion issues if we didn’t do this.

Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'SQlAuthority' to data
Read the rest