比如 CustomerInfo 中有字段 Customer_DutyEMail 中可能有回车,则用如下语句去掉回车
UPDATE dbo.CustomerInfo SET Customer_DutyEMail = replace(replace(Customer_DutyEMail,char(10),''),char(13),'')
比如 CustomerInfo 中有字段 Customer_DutyEMail 中可能有回车,则用如下语句去掉回车
UPDATE dbo.CustomerInfo SET Customer_DutyEMail = replace(replace(Customer_DutyEMail,char(10),''),char(13),'')