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
SQL Update TOP 、Update Order by 和output的使用
原文：https://www.cnblogs.com/DONET-LC/p/13179333.html