sqlserver单引号添加

update xx set xx='select CBM as CBM,CMC,CPYM as CSM from dbo.TBPTZDHZ with(nol
update   xx set xx='select CBM as CBM,CMC,CPYM as CSM from dbo.TBPTZDHZ with(nolock) where BENABLE=1 and CBZ='''+CZDBM+''''