SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create trigger dbo.check_saldo_insert_pessoa on dbo.Pessoa after insert as

    declare @check numeric

    select @check = saldo
    from INSERTED

    if @check > 0
    begin

        rollback transaction

        raiserror('O saldo deve ser igual a: 0 (zero)', 16, 1)

    end
go


/****** Trigger INSTEAD ******/


create trigger MyTriggerInsteadOf2 on dbo.Pessoa INSTEAD OF insert as

    declare @check numeric

    select @check = saldo
    from INSERTED

    if @check > 0
		begin
			raiserror('O saldo deve ser igual a: 0 (zero)', 16, 1)
		end
	else
	begin
	  SET NOCOUNT ON
	  INSERT  dbo.Pessoa  select * from INSERTED
    SET NOCOUNT OFF
	end