两个UPDATE语句 哪个效率高？该如何处理

两个UPDATE语句 哪个效率高？

SQL code

UPDATE ##FZGRZ_KG9050 SET F_DFKM = F_DFKM+'/'+ZWKMZD_KMMC FROM ZWKMZD WHERE ZWKMZD_JS='1' AND F_DFKM LIKE ZWKMZD_KMBH+'%'UPDATE ##FZGRZ_KG9050 SET F_DFKM = F_DFKM+'/'+(select ZWKMZD_KMMC FROM ZWKMZD WHERE ZWKMZD_JS='1' AND F_DFKM LIKE ZWKMZD_KMBH+'%')