UPDATING DATA IN MULTIPLE TABLES

Question

HI I AM STUCK WITH THE PROBLEM
CAN ANYONE HELP ME TO FIGURE OUT THIS

CAN WE UPDATE DATA INTO MULTIPLE TABLES AT THE SAME TIME
CAN WE DO THIS USING STORED PROCEDURE OR TRANSACTION OR IN ANY OTHER WAYS