I have used DELETE with OUTPUT to implement FIFO queue behavior.  In one atomic operation it can delete the first row from the queue table and return the values from that row to a table variable.  Very handy when multiple parallel processes are consuming queue entries.