上代码
begin transaction
declare @error int = 0 --有可能产生的错误号
UPDATE Test2 SET Num = null WHERE ID = 222
set @error +=@@ERROR
UPDATE Test1 SET NAME = null WHERE ID = 1
set @error +=@@ERROR
if(@error<>0)
begin
rollback transaction
end
else
begin
commit transaction
end