Project

General

Profile

PL_INSERT_PL_PROCESS.txt

Truong Nguyen Vu, 09/04/2020 10:59 AM

 
1
INSERT INTO dbo.PL_REQUEST_PROCESS
2
(
3
    REQ_ID,
4
    PROCESS_ID,
5
    STATUS,
6
    ROLE_USER,
7
    BRANCH_ID,
8
    CHECKER_ID,
9
    APPROVE_DT,
10
    PARENT_PROCESS_ID,
11
    IS_LEAF,
12
    COST_ID,
13
    DVDM_ID,
14
    NOTES,
15
    IS_HAS_CHILD,
16
    DEP_ID
17
)
18
VALUES
19
(   '',        -- REQ_ID - varchar(15)
20
    '',        -- PROCESS_ID - varchar(10)
21
    '',        -- STATUS - varchar(5)
22
    '',        -- ROLE_USER - varchar(50)
23
    '',        -- BRANCH_ID - varchar(15)
24
    '',        -- CHECKER_ID - varchar(15)
25
    GETDATE(), -- APPROVE_DT - datetime
26
    '',        -- PARENT_PROCESS_ID - varchar(10)
27
    '',        -- IS_LEAF - varchar(1)
28
    '',        -- COST_ID - varchar(15)
29
    '',        -- DVDM_ID - varchar(15)
30
    N'',       -- NOTES - nvarchar(500)
31
    NULL,      -- IS_HAS_CHILD - bit
32
    ''         -- DEP_ID - varchar(20)
33
    )