Home > database >  After near there are errors
After near there are errors

Time:10-22

1> CREATE the TRIGGER SC_T
2> AFTER the UPDATE OF Grade ON SC
3> REFERENCING
4> OLDROW AS OldTuple,
5> NEWROW AS NewTuple
6 & gt; FOR EACH ROW
7 & gt; WHEN (NewTuple Grade & gt;=1.1 * OldTuple. Grade)
8> INSERT INTO SC_U (Sno, Cno, OldGrade NewGrade)
9> VALUES (OldTuple Sno, OldTuple Cno, OldTuple. Grade, NewTuple. Grade)
10> GO
Message 102, level 15, state 1, server A103 SC_T process, line 2
'AFTER' near a syntax error,
How to do?????
  • Related