存储过程事务处理

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