In this tutorial I want to show how MSSQL is doing implicit conversion when using UNION ALL between various data-types.

Whole content with source-code could be found here https://github.com/bedla/mssql-db-datatype-unionall.