title: SQL server 2008 trigger before insert
body: <p>I am very new to <code>SQL</code> and sorry for asking this is very primary knowledge. My issue as follow.</p>
  
  <p>I have a table called <strong>Group</strong> and <code>minimumVal</code> and <code>maximumVal</code> are two columns. <code>minimumVal</code> always should be less than <code>maximumVal</code>. I want to check this before inserting a new record to the table. If this condition failed data should not inserted into the DB.   </p>
  
  <p>So as per my understanding I though of having a trigger but have no idea how to write this.   </p>
  
  <p>This is what I write so far;  </p>
  
  <pre><code>CREATE TRIGGER tr_Group
  ON Table_Group
  for INSERT
  AS  
  ????
  </code></pre>
  
  <p>Please advise me.</p>