Hi, I want to create a stored procedure that should update multiple tables...following are my insert statements, and I want to make it for update
INSERT INTO EmpPayInfo(EmpId,Sno,SalaryAllowance,AccountNumber,Amount,Fix,CompanyCode,IsActive
INSERT INTO EmpDocument(EmpId,EmpDocument,EmpDocRef,EmpDocPath,EmpDocFile,SNo,CompCode,IsActive
INSERT INTO EmpDependents(EmpId,Sno,Name,Relation,DOB,Passport,Remarks,CompCode,IsActive
INSERT INTO EmpInsurance(EmpId,PrdType,PrdProvider,PrdAccNo,PrdRemarks,sno,CompCode,IsActive
INSERT INTO EmpTraining(EmpId,TrainingDate,TrainingTitle,Remarks,sno,CompCode,IsActive
INSERT INTO EmpProduct(EmpId,RecDate,Product,Qty,Remarks,sno,CompCode,IsActive
INSERT INTO EmpNotes(EmpId,Remarks,sno,CompCode,IsActive