Data type synonyms are included in SQL Server for ISO compatibility. The following table lists the synonyms and the SQL Server system data types that they map to.

Learn about SQL Server data type compatibility and implicit and explicit conversion. When you convert between an application variable and a [!INCLUDE ssNoVersion] result set column, return code, ...

Data conversion transformation or derived column transformation? It depends and you've also got other options.