查询SQL中某表里有多少列包含某字段

select   c.name
            from SYSCOLUMNS as c left join SYSOBJECTS as t on  c.id=t.id 
            where c.name like '这里是某个字段%' and t.name='这里是表名'