--
--20.3.2节示例
--
不符合SARG的查询
SELECT *
FROM Person.Person
WHERE FirstName+' '+LastName='Rob Walters' --写法错误
非SARG和SARG的查询
SELECT *
FROM Sales.Customer
WHERE LEFT(AccountNumber,9)='AW0003011' --不符合SARG
SELECT *
FROM Sales.Customer
WHERE AccountNumber LIKE 'AW0003011%' --符合SARG
