AWSin

/* 다양한 와일드카드와 LIKE 연산자의 쓰임새*/ use AdventureWorks2014 go sp_helpindex [HumanResources.Department] /* AK_Department_Name nonclustered, unique located on PRIMARY Name PK_Department_DepartmentID clustered, unique, primary key located on PRIMARY DepartmentID */ -- p 로 시작하는 문자열 검색 SELECT name from HumanResources.Department WHERE Name LIKE 'p%'; -- index seek SELECT name from HumanResources.Department ..