sql 验证测试

drop procedure OuterPro
go
create procedure OuterPro
as
begin
  declare 
    @a int,
    @b int
  begin tran
    set @a=1
    set @b=2
    declare @c int 
    set @c=@a+@b
    print 'c is :' +convert(varchar(2),@c)

    exec InnerPro 0

    if @@error <>0
    begin
      print 'before rollback'
      rollback tran
      print 'OuterPro find InnerPro error'
    end

     declare @s int 
     set @s=@a*@b
     print 's is :'+convert(varchar(2),@s)

  commit tran
   
end
go

drop Procedure InnerPro
go
create Procedure InnerPro
  @c int
as 
begin
  declare
  @d int ,
  @e int
  set @d=100
  
  set @e=@d/@c
  
  if @@error <>0
  print 'innerPro error'
  else
  print @e

end 
go