insert into query(name,query_string) values('my query','select name,email,phone from users where name=''abc''') 替换函数:declare @a varchar(1000) set @a='''' select @a 只有一个引号select replace(@a,'''','''''') 把一个引号替换成两个
insert into query(name,query_string) values ('my query','select name,email,phone from users where name="abc"')
我一执行此函数,就出现'abc' 附近有语法错误 函数如下: CREATE function chgstr(@strSql as varchar(1000)) returns varchar(1000) as begin return (select replace(@strSql,'''','""')) end
替换函数:declare @a varchar(1000)
set @a=''''
select @a 只有一个引号select replace(@a,'''','''''') 把一个引号替换成两个
函数如下:
CREATE function chgstr(@strSql as varchar(1000))
returns varchar(1000)
as
begin
return (select replace(@strSql,'''','""'))
end