(NOLOCK)
on TUser.userid = TempUser?.id;
</code>
update
<code sql>
-- update 하기
update (table) set (field)=(newvalue) where (condition)
</code>
쿼리 실행 계획얻기
<code sql>
set showplan_a... NewVacationHours int,
ModifiedDate datetime);
UPDATE TOP (10) HumanResources.Employee
SET VacationHour