₦airaland Forum

Hello gurus in da house,am a student and i have a problem on trigger.And the question goes thus:
When a new row is added to a table A , a column X in table B should be increased by one.
Now i need you guys to give me the clue to do this,
or if there is anyone who could write the statement for me.I really do appreciate you all thanks.

Depending on your database of choice, this may vary a little. You can also google for better examples. Just typing this off the top of my head.

create trigger update
on TableB
for update as
if insert(table A)
begin
update table B
set column_B1 = columnB1 + 1
where ,
end