医保赋码撤销失败

wbv123

select * from Pros_Matched_Item where InstitutionItemCode=’189939 ‘

begin tran
update Pros_Matched_Item set Status=0 where Status=1 AND InstitutionItemCode=’189939 ‘
rollback

第一步执行select * from Pros_Matched_Item where InstitutionItemCode=’商品编码 ‘

第二步执行begin tran
update Pros_Matched_Item set Status=0 where Status=1 AND InstitutionItemCode=’189939 ‘
rollback

:
执行完后看和一步执行的结果一样嘛

一样执行第三步，

update Pros_Matched_Item set Status=0 where Status=1 AND InstitutionItemCode=’商品编码 ‘

第三步