Project

General

Profile

UPDATE_SCRIPT DATA.txt

Truong Nguyen Vu, 09/01/2020 01:48 PM

 
1
UPDATE dbo.TR_REQUEST_DOC SET PROCESS_ID='DMMS' WHERE REQ_ID='TRRD00000251012'
2

    
3
EXEC dbo.TR_REQ_PROCESS_CHILD_App @p_REQ_ID = 'TRRD00000251012',       -- varchar(20)
4
                                  @p_PROCESS_ID = 'DMMS',   -- varchar(20)
5
                                  @p_TLNAME = 'phuongtln1',       -- varchar(20)
6
                                  @p_MAKER_ID = 'phuongtln1',     -- varchar(20)
7
                                  @p_TYPE_JOB = 'TP',     -- varchar(20)
8
                                  @p_PROCESS_DES = N'Phê duyệt', -- nvarchar(500)
9
                                  @p_REF_ID = 1,        -- int
10
                                  @p_XMLDATA = NULL     -- xml