can u guys point out some tutorial on how to implement trigger with stored procedure?

i have some topics of interest like how to create multiple table insertion, multiple row update and something like selective table insertion with trigger.. an example : a situation where user supply info which occupy 2 table instead of 3 ...