查询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='这里是表名' 

　　

转载于:https://www.cnblogs.com/qiywtc/p/3719087.html