trigger error

[freefony]

pls correct me
[code=sql]
create trigger trgscore
on dbo.score
for insert
as
declare @matno char(13)
declare @calscore int
declare @type char(30)
begin
insert into grade (quiz) values(sum calscore on score where type = quiz)
end [/code]
error sum is not allowed in this context

[ck9663]

Read the full INSERT INTO syntax.

Here's how to use the SUM()

-- CK