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