CODE EXAMPLE FOR SQL

update top 100 order by sql server

;WITH CTE AS 
( 
SELECT TOP 100 * 
FROM T1 
ORDER BY F2 
) 
UPDATE CTE SET F1='foo'