And the data type is "money"

select$100 as ival

intomytab

select

tname= t.name

,cname= c.name

,coltype= y.name

fromsys.tables t

inner join sys.columns c

on t.object_id = c.object_id

inner join sys.types y

on c.system_type_id = y.system_type_id

wheret.name = 'mytab'

drop table mytab