Project

General

Profile

Download (1.19 KB)

UPDATE DATA_3.txt

Truong Nguyen Vu, 11/30/2020 03:40 PM

 
1 

    		
  

  

    
      2
    
    
      

    		
  

  

    
      3
    
    
      
DELETE FROM TL_SYSROLE_LIMIT  WHERE LIMIT_TYPE='DCNS'


    		
  

  

    
      4
    
    
      
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000012',N'GDK',150000000,N'GDK_DC',N'admin',N'U',NULL,NULL,NULL,N'1',N'DCNS',2,NULL)


    		
  

  

    
      5
    
    
      
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000013',N'PTGD',150000000,N'PTGD_DC',N'admin',N'U',NULL,NULL,NULL,N'2',N'DCNS',2,NULL)


    		
  

  

    
      6
    
    
      
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000014',N'TGD',NULL,N'TGD_DC',N'admin',N'U',NULL,NULL,NULL,N'3',N'DCNS',NULL,NULL)


    		
  

  

    
      7
    
    
      
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LMI00014',N'GDDV',20000000,N'',N'',N'',N'',N'Nov 30 2020 10:33AM',N'',N'',N'DCNS',30,N'')


    		
  

  

    
      8