【摘录】某表含有N个字段超精简模糊查询方法 SELECT * FROM table where CONCAT(a,b,c......) like '%key%' select name from syscolumns where id=object_id(TableName) http://www.cnblogs.com/david1989/p/3843866.html