我想锁定程序 [英] I want lock the procedure

问题描述

先生/女士



我想锁定程序。意味着我有一个应用程序，该应用程序安装在10台计算机上。所有用户都使用存储在服务器上的数据库。当任何用户点击保存按钮然后自动生成我的商店程序生成的代码时，我会有一个注册表。我有一个过程和一个表，该表有一个主键列。我的问题是，当2个用户同时点击保存按钮时，我想要锁定第一个完成任务的第一个进程，然后第二个进程将运行。这就是我想要的。我想清楚我想说的是什么......

Sir/Madam

I want to lock the procedure . means i have a application and that application is installed on 10 computers . All the users are used my database that is store on server. and i have a registration form when any user click on save button then automatically a code generated by my store procedure . i have a procedure and a table and that table has a primary key column . My problem is that when 2 users are click save button on same time then i want lock that process of first one when first one complete the task then second process will be run .thats what i want. i think sound clear what i am want to say ...

推荐答案

请查看以下链接



如何锁定存储过程和sql server中的表 [ ^ ]



http://technet.microsoft.com/en-us/library/ms189823%28v=sql.105%29.aspx [ ^ ]

Please check the below links

how to lock stored procedure, and table in sql server[^]

http://technet.microsoft.com/en-us/library/ms189823%28v=sql.105%29.aspx[^]

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