Project

General

Profile

Download (634 Bytes)

nguyennhk.txt

Luc Tran Van, 11/22/2022 10:26 AM

 
1 
EXEC dbo.sp_generate_inserts @table_name = 'TL_USER', -- varchar(776)
2 
@from = "FROM TL_USER where TLNANME ='nguyennhk'" -- varchar(800)
3 

    		
  

  

    
      4
    
    
      
EXEC dbo.sp_generate_inserts @table_name = 'AbpUserRoles', -- varchar(776)


    		
  

  

    
      5
    
    
      
@from = "FROM AbpUserRoles where UserId =(SELECT ID FROM TL_USER tu WHERE tu.TLNANME ='nguyennhk')" -- varchar(800)


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
EXEC dbo.sp_generate_inserts @table_name = 'CM_EMPLOYEE', -- varchar(776)


    		
  

  

    
      8
    
    
      
@from = "FROM CM_EMPLOYEE WHERE EMP_CODE='06508'" -- varchar(800)


    		
  

  

    
      9
    
    
      

    		
  

  

    
      10
    
    
      
EXEC dbo.sp_generate_inserts @table_name = 'CM_EMPLOYEE_LOG', -- varchar(776)


    		
  

  

    
      11
    
    
      
@from = "FROM CM_EMPLOYEE_LOG WHERE USER_DOMAIN='nguyennhk'" -- varchar(800)