UPDATE TL_SYS_ROLE_MAPPING SET EFF_DATE= CONVERT(DATETIME,'1-1-2000',103) ,EXP_DATE=CONVERT(DATETIME,'1-1-2000',103) WHERE TLNAME IN (SELECT TLNANME FROM TL_USER WHERE RoleName='DISABLE')