DELETE AbpUserRoles WHERE UserId IN (SELECT TU.ID FROM TL_USER TU WHERE TU.TLNANME = 'huonglh') DELETE TL_USER WHERE TLNANME = 'huonglh' DELETE CM_EMPLOYEE_LOG WHERE USER_DOMAIN = 'huonglh' UPDATE TL_USER SET TLNANME = 'bichnn0500', NormalizedUserName = 'bichnn0500' WHERE TLNANME = 'bichnn'