How to quickly change column names

kaga881110

In sql, there are 100 different column names, and I want to add them all to _fw, how can I achieve this quickly.
What about using SQL statements? Or what method?
Such as
a b c d ....
1 1 1 1

I want to become

a_fw b_fw c_fw d_fw ...
1 1 1 1

fanfan1980

select name+'_fw' from syscolumns where id=object_id('table name')
order by colid

hiqwolfzzh

update t2
set t2.name=t2.name+'_fw'
from sysobjects t1, syscolumns t2
where t1.id=t2.id and t1.xtype='u' and t1.name='Your table name'

fanfan1980

create table T(a int, b int, c int, d int)
insert T select 1, 1, 1,1

declare @sql varchar(8000)
set @sql='select '
select @sql=@sql+name+'_fw='+name+',' from syscolumns where id=object_id('T')
order by colid
select @sql=left(@sql, len(@sql)-1), @sql=@sql+' from T'
--print @sql
exec(@sql)

--result
a_fw b_fw c_fw d_fw
----------- ----------- ----------- -----------
1 1 1 1

dream88

---Set uptable system table
sp_configure'allow updates',1
GO
RECONFIGURE WITH OVERRIDE
GO

update syscolumns set name=name+'_fw' from where id=object_id('table name')


- Remember to set it back in the end.

sp_configure'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO
/*
Otherwise your system is dangerous.
It is recommended that you do not do this.
It is best to use stored procedures or other methods to update.
*/

wgfxman

Upstairs correct solution, UP

wgfxman

On the first floor again~
create table T(a int, b int, c int, d int)
insert T select 1, 1, 1,1

declare @sql varchar(8000)
set @sql='select '
select @sql=@sql+name+'_fw='+name+',' from syscolumns where id=object_id('T')
order by colid
select @sql=left(@sql, len(@sql)-1), @sql=@sql+' from T'
--print @sql
exec(@sql)