Whether the stored procedures in SQL Server contain transactions and whether the returned results are processed successfully

-- Replace the original unitcodingCommunityReplace data with the new unitcoding
Create procedure DBO. sp_changeunitcoding
(
@ Oldunitcoding varchar (20 ),
@ Newunitcoding varchar (20)
)
As
Declare @ returnvalue varchar (1)
Begin Tran T1

-- 1
Update tab_a set unitcoding = @ newunitcoding where unitcoding = @ oldunitcoding
If @ error <> 0 goto err_do
-- 2
Update tab_ B set unitcoding = @ newunitcoding where unitcoding = @ oldunitcoding
If @ error <> 0 goto err_do
-- 3
Update tab_c set unitcoding = @ newunitcoding where unitcoding = @ oldunitcoding
If @ error <> 0 goto err_do

Commit Tran T1
Set @ returnvalue = '1'
Goto OK _do

Err_do:
Rollback Tran T1
Set @ returnvalue = '0'

OK _do:
Select @ returnvalue
Go