Nice question. I learned something new about the Coalesce function and NULL values.

IMO: The actual data type for a NULL value once inserted into a table has to do with the fact that a true NULL is a lack of anything at all.

However, SQL server has to use something to maintain that the feild should return a NULL so it uses an int.