title: How to abort an insert of multiple rows in a trigger
body: <p>With sql Server 2005.
  I have declared a trigger that get fired "AFTER INSERT, UPDATE" , in this trigger I'm using a WHILE and a CURSOR to loop on the INSERTED table's rows.
  When I find a row that does not sotisfy a specific condition:</p>
  
  <p>I want the trigger to rise an error and do not insert any of the rows that fired the trigger (not even those that already satisfaied my condition).  &lt;--- I don't know how to do this!</p>
  
  <p>Can you tell me how can I rise the error and prevent the insertion?</p>