in store procedure how to use insert,delete,update,

Question

In store procedure how to use insert,delete,update, with different table with example query