When the data type having a different number of digits is converted, the value will be truncated as the most accurate number. For example, SELECT CAST (10.6496 AS INT) results are 10.
When the conversion is converted, if the decimal number of target data types is less than the number of decimal numbers of the source data type, the value to be converted will be rounded. For example, the result of CAST (10.3496847 as Money is $ 10.3497.
SQL Server returns an error message when converting non-digital types of char, nchar, varchar, or nvarchar data to INT, FLOAT, NUMERIC, or DECIMAL. When a null string ("") is converted to Numeric or Decimal, SQL Server will return an error message.
