双引号替换成单引号:
set @strwhere=replace(@strWhere,'''''','''')
单引号替换成双引号:
set @strwhere=replace(@strWhere,'''','''''')
此外还有一些在平常中需要替换的:
set @strwhere=replace(@strWhere,'--','')
set @strwhere=replace(@strWhere,';','')
双引号替换成单引号:
set @strwhere=replace(@strWhere,'''''','''')
单引号替换成双引号:
set @strwhere=replace(@strWhere,'''','''''')
此外还有一些在平常中需要替换的:
set @strwhere=replace(@strWhere,'--','')
set @strwhere=replace(@strWhere,';','')
转载于:https://www.cnblogs.com/wzg0319/archive/2010/05/27/1745599.html