Windows Service / SQL Server并发问题
我有一个充当任务队列的数据库表。插入此表的位置在其他地方(例如表触发器等)。
我有一个执行以下操作的多线程Windows服务:
Using a Stored Procedure, reads the queue table for rows marked as 'todo', and marks the rows it read as 'doing'.
Processes those rows.
Marks the rows as 'done'.
Ideal Situation:
When the se...