UPDATE TR_REQUEST_DOC SET BRANCH_DVMS = 'BRN000000000400', DMMS_ID = 'DMMS00000000015' WHERE REQ_ID = 'TRRD00000257841' UPDATE PL_REQUEST_PROCESS SET DVDM_ID = 'DMMS00000000015' WHERE REQ_ID = 'TRRD00000257841' AND PROCESS_ID = 'DMMS' INSERT dbo.PL_PROCESS ( REQ_ID, PROCESS_ID, CHECKER_ID, APPROVE_DT, PROCESS_DESC, NOTES ) VALUES ( 'TRRD00000257841', -- REQ_ID - varchar(15) 'DMMS', -- PROCESS_ID - varchar(10) 'vanpt2', -- CHECKER_ID - varchar(15) GETDATE(), -- APPROVE_DT - datetime N'Chuyển phiếu về Chi Nhánh Đồng Nai theo yêu cầu', -- PROCESS_DESC - nvarchar(1000) N'Chuyển phiếu về Chi Nhánh' -- NOTES - nvarchar(1000) )