22,207
社区成员
发帖
与我相关
我的任务
分享
update tableName
set columnName=replace(columnName,'\\','/')
set @i='https://www.baohecj.net\\2018144948367?w=200&h=200\\SHJ000000090.jpg';
select replace(@i,'\\','/') as result;
DECLARE @str NVARCHAR(200)='https://www.baohecj.net\2018144948367?w=200&h=200\SHJ000000090.jpg'
SELECT REPLACE(@str,'\','/')