Technique and Simple Utility to Determine the Datatype of a Scalar T-SQL Expression

Note: post revised to take into consideration tips from comments The other day, I was working with a query where...