title: Row locks - manually using them
body: <p>I basically have an application that has, say 5 threads, which each read from a table.  The query is a simple SELECT TOP 1 * from the table, but I want to enforce a lock so that the next thread will select the next record from the table and not the locked one.  When the application has finished it's task, it will update the locked record and release the lock and repeat the process again.  Is this possible?</p>