select a.name,b.value from syscolumns as a left outer join sysproperties as b on a.id=b.id and b.smallid=a.colid where a.id=object_id('表名')
