select b.name,a.colid,a.name ,(select systypes.name+‘(‘+cast(a.length/2as varchar(10))+‘)‘ from systypes where a.xusertype=systypes.xusertype ) type fromsyscolumns a left outer join sysobjects b on a.id=b.id where b.xtype=‘U‘and b.name = ‘hq_hotel‘ order by b.name,a.colid
原文：https://www.cnblogs.com/ShaYeBlog/p/11644681.html