如何快速替换一个数据表中很多连续列的值？谢谢

ゞ⑧鸢の翔

一个数据表里头有很多列，每个列有一个数值，现在要替换这个数值，要怎么操作？谢谢！我看了SSMS编辑栏中有个replace功能不过就是没作用，
update不懂如何写才好！

站长苏飞

[SQL] 纯文本查看 复制代码

update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,'=','')  
update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,'<','')  
update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,'-','')  
update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,'~','') 
 update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,']','')  
update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,'[','')  
update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,'$','')  
update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,'{','')  
update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,'}','')  
update dbo.DomainInFo_FIp set D_Domain=Replace(D_Domain,'·','')

http://www.sufeinet.com/thread-401-1-1.html
做个参考吧