title: Trigger to prevent Insertion for duplicate data of two columns
body: <p>I am working on <code>SQL Server 2008R2</code>, I am having the following Table</p>
  
  <pre><code>ID     Name     date
   1     XYZ      2010
   2     ABC      2011
   3     VBL      2010
  </code></pre>
  
  <p>Now i want to prevent insertion if i have a Data although the ID is different but data is present</p>
  
  <pre><code> ID    Name     date
    4    ABC      2011
  </code></pre>
  
  <p>Kindly guide me how should i write this trigger.  </p>