您可以使用ROWCOUNT

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'