如何从数据库中选择记录并通过原子查询对其进行更新

UPDATE [table]
SET Status = \'InProcess\'
OUTPUT deleted.*
WHERE Status = \'Pending\'

create table T (ID int identity, Status varchar(15))

;with cte as
(
  select top 1 *
  from T with (rowlock, readpast)
  where Status = \'Pending\'
  order by ID
)
update cte
set Status = \'InProcess\'
output inserted.ID, inserted.Status

UPDATE [table]
SET Status = \'InProcess\'
WHERE Status = \'Pending\'

declare temp1, temp2, ...;
update table
   set temp1=column1,
       temp2=column2, ... 
       column1=expression1,
       column2=expression2, ...
where conditions;
select temp1, temp2, ...;