sql update top 100 code example

Example 1: update top 100 sql

update top (100) table1 set field1 = 1

Example 2: sql update top 100

update top (100) table1 set field1 = 1