摘要： select len(@str)-len(replace(@str,',','')) 阅读全文

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