UPDATE TOP 1

当两记录一样时，用以下脚本修改

UPDATE top (1) dbo.table
SET [Status] = 1
WHERE [OrderId] = '1337' and [Status] = 0;
GO

UPDATE top (1) dbo.table

SET [Status] = 1

WHERE [OrderId] = '1337' and [Status] = 0;