|
|
От: |
Pavel_Lechenko
|
http://www.sdpm.ru |
| Дата: | 28.04.04 06:05 | ||
| Оценка: | |||
CREATE TRIGGER GenBall_Calc ON Abitur
FOR INSERT, UPDATE
AS
if not UPDATE(Ab_GenBall) begin
update Abitur
set Abitur.Ab_GenBall=inserted.Ab_BallRus+inserted.Ab_SecBall+inserted.Ab_Courses
from inserted where inserted.id = Abitur.id
end