CREATE PROCEDURE TryMe AS

SET XACT_ABORT ON

begin transaction

insert into DPTOS (Code, Name) values ('AB', 'NameAB')

insert into dptos (Code, Name) values ('DE', 'NameDE')

update dptos set Code = 'AB' where code = 'DE'

if...