Project

General

Profile

UPDATE_TLNAME.txt

Luc Tran Van, 04/28/2023 01:58 PM

 
1
UPDATE TL_USER SET TLNANME = 'duchv', NormalizedUserName = 'duchv' WHERE TLNANME = 'duchn'
2
UPDATE CM_EMPLOYEE_LOG SET USER_DOMAIN = 'duchv' WHERE USER_DOMAIN = 'duchn'
3

    
4
UPDATE TL_USER SET TLNANME = 'hanhdh0807', NormalizedUserName = 'hanhdh0807' WHERE TLNANME = 'hanhdh'
5
UPDATE CM_EMPLOYEE_LOG SET USER_DOMAIN = 'hanhdh0807' WHERE USER_DOMAIN = 'hanhdh'
6

    
7
UPDATE TL_USER SET TLNANME = 'duyln', NormalizedUserName = 'duyln' WHERE TLNANME = 'duyln2600'
8
UPDATE CM_EMPLOYEE_LOG SET USER_DOMAIN = 'duyln' WHERE USER_DOMAIN = 'duyln2600'
9

    
10
UPDATE TL_USER SET TLNANME = 'thongnv1704', NormalizedUserName = 'thongnv1704' WHERE TLNANME = 'thongnv'
11
UPDATE CM_EMPLOYEE_LOG SET USER_DOMAIN = 'thongnv1704' WHERE USER_DOMAIN = 'thongnv'