how can I Update top 100 records in sql server September 15, 2022 by Tarik Note, the parentheses are required for UPDATE statements: update top (100) table1 set field1 = 1