update top(1) Products with(updlock,readpast) set Status = 1 output Deleted.Id as PoolSkuId from (select top 1 Id from Products where Deleted = 0 and Status = 0 order by createdTime desc) t1 where Products.Id = t1.Id
2024-01-02 15:02:04
update top(1) Products with(updlock,readpast) set Status = 1 output Deleted.Id as PoolSkuId from (select top 1 Id from Products where Deleted = 0 and Status = 0 order by createdTime desc) t1 where Products.Id = t1.Id