使用 TOP 子句限制UPDATE 语句更新的数据

 USE AdventureWorks2008R2;
 UPDATE TOP (10) Sales.Store
 SET SalesPersonID = 276
 WHERE SalesPersonID = 275;
 GO

 UPDATE HumanResources.Employee
 SET VacationHours = VacationHours + 8
 FROM (SELECT TOP 10 BusinessEntityID FROM HumanResources.Employee
   ORDER BY HireDate ASC) AS th
 WHERE HumanResources.Employee.BusinessEntityID = th.BusinessEntityID;
 GO