HOW TO UPDATE TOP 100 ROWS SQL code example Example: update top 100 sql update top (100) table1 set field1 = 1