create table #t
(
[col_name] varchar(50),
col_id varchar(50),
col_typename varchar(50),
col_len varchar(50),
col_prec varchar(50),
col_scale varchar(50),
col_basetypename varchar(50),
col_defname varchar(50),
col_rulname varchar(50),
col_null varchar(50),
col_identity varchar(50),
col_flags varchar(50),
col_seed varchar(50),
col_increment varchar(50),
col_dridefname varchar(50),
text1 varchar(50),
col_iscomputed varchar(50),
text2 varchar(50),
col_NotForRepl varchar(50),
col_fulltext varchar(50),
col_AnsiPad varchar(50),
col_DOwner varchar(50),
col_DName varchar(50),
col_ROwner varchar(50),
col_RName varchar(50),
collation  varchar(50),
ColType varchar(50),
other1 varchar(50),
other2 varchar(50)
)
insert into #t 
exec sp_mshelpcolumns 'tb' 

select col_basetypename,[col_name],col_id from #T 
drop table #T
/*
col_basetypename   col_name  col_id
------------------ --------- --------
int                id        1
varchar            name      2
*/