Create a trigger in sql server 2008

Question

Hi, 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

movie_ratings

the primary key is = movie_rating

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.

Thanks

Answer 1

If you are using sql Managemnt studio than

press Ctrl+Alt+t which display templates for the different database object in that select trigger template and create trigger as you want

check this out will help

Answer 2

Here is the syntax to create a trigger which will fire when a row is inserted.

create trigger movie_rating_added on movie_ratings for insert
as 
   -- trigger code goes here

go

Inside the trigger, you have access to a virtual table called inserted, which has the same schema as movie_ratings, but which contains only the rows which were inserted.

I'm not clear on exactly what you want the trigger to do, but for example you could do something like this:

create trigger movie_rating_added on movie_ratings for insert
as
    update m set last_action = "rating added"
    from movies m
    join inserted i on i.movie_id=m.id
go

Which is supposing the existence of some fields and tables that you might not have, but hopefully it gives you a useful example.