select * from dbo.luDefect
update luDefect
set Description= REPLACE(Description, CHAR(13), '')
where REPLACE(Description, CHAR(13), '<br>') like '%<br>%'
SQL 替换回车符
最新推荐文章于 2023-10-23 09:37:31 发布
select * from dbo.luDefect
update luDefect
set Description= REPLACE(Description, CHAR(13), '')
where REPLACE(Description, CHAR(13), '<br>') like '%<br>%'