RT

insert into #tablename
exec sp_column table

试试
表要先建立好，好象

select name  into tablename from syscolumns where id=object_id('table_name') 自动生成个表tablename