只针对单个表的所有列 declare @sql varchar(8000) select @sql=isnull(@sql+',','')+'replace('+name+','+''''+''''+','+''''+'/ '+''''+' )' from master..syscolumns where id=(select id from master..sysobjects where name ='tab') set @sql= 'select '+@sql+' from tab' exec(@sql)
update t_t set a = replace(a, ' ', '/')
isnull(col,'/')
replace(col,' ','/')不知道楼主说的空是值null还是指空格?
declare @sql varchar(8000)
select @sql=isnull(@sql+',','')+'replace('+name+','+''''+''''+','+''''+'/ '+''''+' )'
from master..syscolumns where id=(select id from master..sysobjects where name ='tab')
set @sql= 'select '+@sql+' from tab'
exec(@sql)