select * from table where name like '%' + @name + '%' 转载于:https://www.cnblogs.com/cqsar/articles/1306372.html