失落小羊

摘要： 多表Contains查询最初用OR，效率很低，查了资料改用union ，每个contains为一个子查询select * from pdt where Contains(name,'a')unionselect * from pdt inner join Company as c where Contains(c.name,'c')http://support.microsoft.com/kb/2264562/zh-cn 阅读全文