update sql + 100 code example

Example: update top 100 sql

update top (100) table1 set field1 = 1