如何锁定流程 [英] How Lock the process

问题描述

想要查询以锁定一个进程..
Wen，我们先进入下个月的流程，我们要通过创建设置来锁定上个月的计算..
对于整个表，我们应该设置通用锁定过程.
需要查询Sql2005

Want Query to Lock one process..
Wen we go to next month process first we want to lock previous month calculation by creating settings..
This should be for whole table we have set common lock procedure.
Need query for Sql2005

推荐答案

这完全取决于您的业务需求，过程和数据库设计.您所做的完全取决于您.除非设计需要，否则不需要锁定"任何东西，具体取决于您对锁定"的定义.

它可能很简单，就像从生产表中获取记录并将它们移动到某种存档表中一样.我(这里没有人)对您的需求和设计有什么了解，因此无法确切地说.

This is ENTIRELY dependant on your business requirements, procedures, and your database design. What you do is entirely up to you. You don''t NEED to "lock" anything unless your design requires it, depending on what your definition of "lock" is.

It may be as simple as taking the records from the production tables and moving them to archive tables of some kind. I, and nobody here, has any idea of what your requirements and design are, so it''s impossible to say exactly.

这篇关于如何锁定流程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！