select 'update t_dw_jbxx set pcsdm=''' +temp.ybdz+ ''' where dwdm= ''' +rtrim(temp.bkh) + ''';' as updatesql from ( select sfz, bkyxdm,ybdz,bkh from bssxx where xm like '张%') temp
sqlServer脚本转义
最新推荐文章于 2022-05-05 05:05:47 发布
select 'update t_dw_jbxx set pcsdm=''' +temp.ybdz+ ''' where dwdm= ''' +rtrim(temp.bkh) + ''';' as updatesql from ( select sfz, bkyxdm,ybdz,bkh from bssxx where xm like '张%') temp