how can I Update top 100 records in sql server

Question

Hi Guys,

I want to update Top 100 records in sql server . I have a table T1 with fields F1 and F2. T1 has 200 records. I want to update F1 field of Top 100 records. How can i can update in sql server.

Thanks Rajesh

Answer 1

update top (100) table1 set field1 = 1

Answer 2

It will work in sql 2005 but not in sql 2000. please mention.

Answer 3

update tb set f1=1 where id in (select top 100 id from tb where f1=0)