BEGIN TRANSACTION
begin
insert into dbo.bu_list values('11111111111','','','')
insert into dbo.ccc_list values('11111111111','')
end
IF(@@error!= 0)
BEGIN
ROLLBACK TRANSACTION
END
ELSE
BEGIN
COMMIT TRANSACTION
END
Go
BEGIN TRANSACTION
begin
insert into dbo.bu_list values('11111111111','','','')
insert into dbo.ccc_list values('11111111111','')
end
IF(@@error!= 0)
BEGIN
ROLLBACK TRANSACTION
END
ELSE
BEGIN
COMMIT TRANSACTION
END
Go