Update ... Where Primary key column in (SELECT TOP 100 primary key column from table1) or set rowcount 100 Update table set ... set rowcount 0
