create table #t(rowid int)
insert into #t select 1
go
declare @s1 varchar(8000),@s2 varchar(8000)
set @s1=''
set @s2=''
select @s1=@s1+'alter table #t add col'+rtrim(colid)+' varchar(80)'+char(13),
@s2=@s2+'update #t set col'+rtrim(colid)+'='''+name+''''+char(13)
from syscolumns where id=object_id('tabname') order by colid
print @s1
print @s2
exec(@s1)
exec(@s2)
alter table #T drop column rowid
select * from #T
go