SQL Server:替换文本中的回车和换行符
时间:2021-07-01 10:21:17
帮助过:5人阅读
替换回车符
update master_location
SET street_number
= REPLACE(street_number,
CHAR(
13),
‘‘)
--替换换行符
update master_location
SET street_number
= REPLACE(street_number,
CHAR(
10),
‘‘)
SQL Server:替换文本中的回车和换行符
标签:update style weight pre serve sql location -- class