create table tb(a int,b float,c decimal(10,2),d varchar(10))

go

select name,system_type_id from sys.columns where object_id=object_id('tb')

/*

name                                                                                                                             system_type_id

-------------------------------------------------------------------------------------------------------------------------------- --------------

a                                                                                                                                56

b                                                                                                                                62

c