Thanks for this posting. It is great! If you can add other data types such as

when data_type like 'uniquidentifier%' then 'Guid '

when data_type in ('money','decimal','float') then 'float '

and so on

then it will be perfect.