INSERT INTO dbo.PL_ROLE_DATA_CONFIG ( ROLE_TYPE, BRANCH_ID, DEP_ID ) VALUES ( 'PL_REQUEST_DOC_ALL', -- ROLE_TYPE - varchar(100) 'thuynt2', -- BRANCH_ID - varchar(100) '' -- DEP_ID - varchar(100) ) INSERT INTO dbo.PL_ROLE_DATA_CONFIG ( ROLE_TYPE, BRANCH_ID, DEP_ID ) VALUES ( 'PL_REQUEST_DOC_ALL', -- ROLE_TYPE - varchar(100) 'vanpt2', -- BRANCH_ID - varchar(100) '' -- DEP_ID - varchar(100) ) INSERT INTO dbo.PL_ROLE_DATA_CONFIG ( ROLE_TYPE, BRANCH_ID, DEP_ID ) VALUES ( 'PL_REQUEST_DOC_ALL', -- ROLE_TYPE - varchar(100) 'hoattm', -- BRANCH_ID - varchar(100) '' -- DEP_ID - varchar(100) ) SELECT * FROM dbo.TL_USER WHERE TLNANME LIKE 'hoa%'