• OK, I have found a benefit of the CONCAT function in SQL 2012. it is automatically converting data types to strings and outputting them rather than giving you data type mismatches, and forcing you to convert all the inputs. I can also see how people will consider this lazy and at least in the case of DateTime fields, you would generally convert to a specific format.

    but instead of coding :

    SELECT 'Current Time ' + CAST(GETDATE() AS VARCHAR(20))

    you could use

    SELECT CONCAT('Current Time ', GETDATE())