declare @Error int
begin tran
set @Error=0
select @DeptName=DeptName from B_Dept where DeptNo=@DeptNo
set @Error=@Error+@@Error
if @Error<>0
begin
rollback
end
else
begin
commit
end
GO
declare @Error int
begin tran
set @Error=0
select @DeptName=DeptName from B_Dept where DeptNo=@DeptNo
set @Error=@Error+@@Error
if @Error<>0
begin
rollback
end
else
begin
commit
end
GO