title: SQL Trigger to update a field on insert if the inserted value conflicts with the unique constraint
body: <p>I have a Table called Albums which contains a field IsDeleted and a field "Name". 
  Name is a unique key. My Question is:</p>
  
  <p>Can I create a trigger which updates IsDeleted to False if it is set to True and the same name is inserted into the table by the user?</p>
  
  <p>Of course the insert statement should somehow be changed to an update statement.</p>
  
  <p>I'm Using MSSQL 2008 and I'm very new to triggers and SQL ingeneral</p>
  
  <p>Thanks for your help!</p>