如果执行下面sql语句会报错, 语句未正常结束。
update a
set name= 'select XX from b where XXX = '[Plant]''
where comment1 = 'select XX from b where XXX =[Plant]'
把值里面的单引号替换为两个单引号即可
update a
set name= 'select XX from b where XXX = ''[Plant]'''
where comment1 = 'select XX from b where XXX =[Plant]'