title: Create a trigger in sql server 2008
body: <p>I am trying to create a trigger for a cinema database.
  I need it to update once a rating is added for a movie showing the text "rating added". The table name is </p>
  
  <p>movie_ratings</p>
  
  <p>the primary key is = movie_rating</p>
  
  <p>I am not really sure how to do it, I have looked online but still are not too sure. I was wondering if anyone could help.</p>
  
  <p>Thanks</p>