It is a common requirement in SQL server development ... N rows we are updating. 2) Using CTE ;WITH CTE AS ( SELECT TOP 100 * FROM Table1 ORDER BY F2 ) UPDATE CTE SET field1=1 In the above query we ...