使用Transaction查询如何只提交一条记录 [英] using Transaction query how to commit only one record

问题描述

我读了这个记录



设置交易隔离级别可重复阅读;

开始交易;



SELECT * FROM macntmst，其中ACODE ='A0052'



SELECT * FROM macntmst，其中ACODE ='A0051'



COMMIT TRANSACTION;



不允许更新此记录其他人记录



更新pharma.dbo.macntmst设置ACCAT = 00200001其中ACODE ='6101'

i ma read this record

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
BEGIN TRANSACTION;

SELECT * FROM macntmst where ACODE ='A0052'

SELECT * FROM macntmst where ACODE ='A0051'

COMMIT TRANSACTION;

don't allow to update this record other person record

update pharma.dbo.macntmst set ACCAT =00200001 where ACODE ='6101'

推荐答案

我明白你需要更新记录内的记录交易，如果是这样，请尝试将该更新查询放入交易中。



BEGIN TRANSACTION;

更新pharma.dbo.macntmst set ACCAT = 00200001，其中ACODE ='6101'

COMMIT TRANSACTION;

I understand that you need to update the record within the transaction, if it so , try to put that update query within the transaction.

BEGIN TRANSACTION;
update pharma.dbo.macntmst set ACCAT =00200001 where ACODE ='6101'
COMMIT TRANSACTION;

这篇关于使用Transaction查询如何只提交一条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！