批量去除varchar,nvarchar字段多余空格

http://topic.youkuaiyun.com/u/20100329/19/78e617a6-1259-4dd2-a5ac-22c70f9b20c1.html?seed=1239289930&r=64279791#r_64279791

 

 

declare @s nvarchar(500)
declare c cursor for  
    select 'update ['+a.name+']'+ ' set ['+b.name+']=ltrim(rtrim(['+b.name+']))'
    from sysobjects a
        join syscolumns b
            on a.id=b.id
            and b.xtype in(167,175)
    where a.xtype='U '
open c  
fetch next from c into @s
while @@fetch_status=0  
begin  
    exec(@s)
    fetch next from c into @s
end  
close c  
deallocate c