substr/ instr /*updatehr_user_qy0331_oklsetl.login_name_new=substr(l.login_name,1,instr(l.login_name,'@')-1)||to_char(to_date(l.从身份证号码截取出生日期,'yyyy/mm/dd'),'mmdd')||substr(l.login_name,instr(l.login_name,'@'))wherel.从身份证号码截取出生日期isnotnullandl.同名否='same'andl.login_nameisnotnul
登录名重复: 增加人员生日变更登录帐号为唯一 updatehr_user_qy0331_oklsetl.login_name_new=substr(l.login_name,1,instr(l.login_name,'@')-1)||to_char(to_date(l.从身份证号码截取出生日期,'yyyy/mm/dd'),'mmdd')||substr(l.login_name,instr(l.login_name,'@'))wherel.从身份证号码截取出生日期isnotnullandl.同名否='same'andl.login_nameisnotnull
substring selectSUBSTRING(OriginalData,9,2)+':'+SUBSTRING(OriginalData,11,2),cardtime,OriginalDatafromV_CardData whereCardTime<>SUBSTRING(OriginalData,9,2)+':'+SUBSTRING(OriginalData,11,2)
[ 图 ] Update selectPProduceID,SUBSTRING(PProduceID,3,len(PProduceID))fromdbo.Carton_BG_PProduceInfo wherePProduceIDlike'2015%'; select*intoCarton_BG_PProduceInfo160113fromCarton_BG_PProduceInfo; updateCarton_BG_PProduceInfosetPProduceID=SUBSTRING(PProduceID,3,len(PProduceID)) wherePProduceIDlike'2015%'