Trigger for Inserting
The following code sample shows how to create a trigger for Inserting
create trigger tg_insert on StudentsMarks after insert
as
begin
declare @StudentId int ,@StudentName varchar(25),@Total int
select @StudentId=StudentId,@StudentName=StudentName,@Total=Subject1+Subject2+Subject3+Subject4 from inserted
insert into Studentstotal values(@StudentId,@StudentName,@Total)
end
|
No responses found. Be the first to respond and make money from revenue sharing program.
|