How to update only one row in a table?

Question

How to I can update only one record in a table?

Table:

name       name1       name2 ---------------------------- xx         xy          xz xx         xx          xx xx         xx          xx xx         xx          xx xy         xx          zz 

Update query:

UPDATE table1  SET name2 = '01'  WHERE name1='xx' 

I need update only one row per time.

Answer 1

you can use ROWCOUNT

SET ROWCOUNT 1  UPDATE table1  SET name2 = '01'  WHERE name1='xx'  SET ROWCOUNT 0 

or you can use update top

UPDATE TOP (1) table1  SET name2 = '01'  WHERE name1='xx'