您好,欢迎访问一九零五行业门户网

查询[LIKE]SqlServer特殊字符

http://www.dqhxz.com/post_572.html 如 select @emailtitle = replace(@emailtitle,' [ ',' [[] ') --1 select @emailtitle = replace(@emailtitle,' % ',' [%] ') --2 select @emailtitle = replace(@emailtitle,' _ ',' [_] ') --3 select @emailtitle =
http://www.dqhxz.com/post_572.html

select @emailtitle = replace(@emailtitle,'[','[[]')--1
select @emailtitle = replace(@emailtitle,'%','[%]')--2
select @emailtitle = replace(@emailtitle,'_','[_]')--3
select @emailtitle = replace(@emailtitle,'^','[^]')--4
其它类似信息

推荐信息