分布式程序对同一表进行操作时的sql

分布式程序对同一表进行操作,为了不使多个进程同时打嘴仗一条sql语句,可用下面的sql

@"declare @id int

                                UPDATE NorthBoundQueue SET LastProcessTime = getdate(),@id=t1.NorthBoundQueueID 
                                FROM (SELECT TOP 1 * FROM NorthBoundQueue where DATEADD(millisecond, " + timeOut + @", LastProcessTime) < getdate() ORDER BY CreateTime ) AS t1
                                WHERE NorthBoundQueue.NorthBoundQueueID = t1.NorthBoundQueueID AND DATEADD(millisecond, 30000, NorthBoundQueue.LastProcessTime) < getdate()

                                SELECT TOP 1 * FROM NorthBoundQueue where NorthBoundQueue.NorthBoundQueueID = @id ";