how to create and use fo trigger in sql 8

i hav written this query.....................
my column name is hindi ,english ,economics ,computer ,accounts ,totalmarks and table name is marks
create trigger trg_insert on marks
for
insert
as
begin
update marks set totalmarks=hindi+english+accounts+computer+economics where s_id=1
print upper('Total marks saved')
end
but is is not firing trigger