如test表的AA字段"123
"
更改后结果为"123"我用下面语句
update test
set AA = REPLACE(AA,CHAR(13)+CHAR(10),'')运行后提示:Argument data type text is invalid for argument 1 of replace function.我用的是SQL2000谢谢!
"
更改后结果为"123"我用下面语句
update test
set AA = REPLACE(AA,CHAR(13)+CHAR(10),'')运行后提示:Argument data type text is invalid for argument 1 of replace function.我用的是SQL2000谢谢!
--try
update test
set AA = REPLACE(cast(AA as varchar(max)),CHAR(13)+CHAR(10),'')
set @a= 'sd
sdfs ' print @a print replace(replace(@a,char(10), ' '),char(13), ' ')
update test
set AA = replace(replace(AA,char(10), ' '),char(13), ' ')
set @i ='safdf
FDG'select @i=replace(@i,'
','')SELECT @i
text,ntext类型,用cast转换为varchar类型替换字符串,要是该字符串长度超过8000个字符,肯定是要出错的。