update 表 set 内容 = replace(内容,' ',' ') where 条件
楼上的兄弟,好像ntext类型的是不能用update来更新的
replace肯定是不行的,它只支持字符型做参数。
select replace(cast(cast('[aaaaaaaa]' as ntext) as varchar),'a','x') 把 cast('[aaaaaaaa]' as ntext 替换为你的列名:select replace(cast(FieldName as varchar),'a','x')
测试: select cast('[aaaaaaaa]' as ntext) as F1 into #T select * from #T update #T set F1 = replace(cast(f1 as varchar),'a','' ) select * from #T drop table #T
把 cast('[aaaaaaaa]' as ntext 替换为你的列名:select replace(cast(FieldName as varchar),'a','x')
select cast('[aaaaaaaa]' as ntext) as F1 into #T
select * from #T
update #T set F1 = replace(cast(f1 as varchar),'a','' )
select * from #T
drop table #T