title: show the warning message and save the transaction
body: <p>i want a create trigger like that. when balance over 500 thats save the transaction but not show any message. How i fix this.</p>
  <pre><code>create Trigger [dbo].[balance] On [dbo].[orders]
      After Insert as
          Declare 
               @or_kod    VARCHAR(25),
              @balance float(10),
              @message varchar(max)
          Begin 
           /*
              Message
          */
          select  @message= 'Balance over 500 !!!'
          /*
              or_kod
          */
          Select @or_kod = or_customer_kod From inserted 
          
          /*
              Balance
          */
          Select  @balance = dbo.fn_accountBalance('',0,or_customer_kod,'','',NULL,NULL,NULL,0,0,0,0,0) From inserted  
          /*
              IF Balance over 500 
          */
          IF (  @balance&gt;500)
          begin
          commit TRANSACTION 
          
  raiserror(@message,10,1)
  end
  end 
  </code></pre>