Question

存储过程中单引号中还有一个单引号该怎么办,如：exec('select * from tb where a='xx'')

Answer 1

这样试试,不行的话再各删掉一个单引号试试

exec('select * from tb where a='''xx'''')