Skip to content

Data Type & Conversion errors

Conversions, overflows, truncation, divide by zero and subqueries that return more rows than expected.

245 Conversion failed converting varchar value to intA text value could not be converted to a number. 8114 Error converting data type X to YA value could not be converted to numeric, decimal, float or bigint, often through a procedure parameter. 8115 Arithmetic overflow converting expression to data typeA value was too large for the target numeric type. 8134 Divide by zero error encounteredAn expression divided by zero. 512 Subquery returned more than 1 valueA scalar subquery returned more than one row. 8152 String or binary data would be truncatedA value was too long for the column; the bare message used at compatibility level 140 or lower. 2628 String or binary data would be truncated (named column)The detailed truncation message (compatibility level 150 or higher) naming the table, column and truncated value. 241 Conversion failed when converting date and/or time from character stringText could not be read as a date: placeholders, impossible dates or text + datetime. 242 The conversion of a varchar data type to a datetime data type resulted in an out-of-range valueDay and month read in the wrong order (DATEFORMAT/language) or a date outside the datetime range. 220 Arithmetic overflow error for data type, valueA value did not fit tinyint or smallint; the message shows the value. 468 Cannot resolve the collation conflictTwo text columns with different collations were compared, joined or combined in a UNION. 206 Operand type clashTwo types with no implicit conversion met: int into a date column, datetime2 + 1, or the wrong table type for a TVP. 402 The data types are incompatible in the operatorAn operator such as = or + got types it cannot combine: text/ntext/xml compared with a string, or a string + uniqueidentifier. 8116 Argument data type is invalid for argument of functionA built-in function got the wrong type in one argument, such as SUBSTRING on an int or DATEADD with a varchar number. 8169 Conversion failed when converting from a character string to uniqueidentifierText that is not a valid GUID (a placeholder, an empty string, missing hyphens) was converted to uniqueidentifier.
No errors in this category match your search. Search the whole library.

Other categories