declare @a varchar(100)
set @a='sd
sdfs'print @aprint '-----------------'print replace(replace(@a,char(10),''),char(13),'')
set @a='sd
sdfs'print @aprint '-----------------'print replace(replace(@a,char(10),''),char(13),'')
','$')或:update tablename set field1=replace(replace(field1,char(10),''),char(13),'$')