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 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.

It’s surprisingly easy to stop query folding happening in Power Query by changing the data type of a column. This is mentioned in the docs here, and it’s something several people have b… ...

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