如何取出表的所有字段并赋值给变量

[nongfucha]

如何取出表的所有字段并赋值给变量
Select name From syscolumns？

[打一壶酱油]

declare @str varchar(max)
set @str = ''

select @str = @str + ',' + [name] from sys.columns
where id = object_id('表名') and xtype = 'u'

select stuff(@str,1,1,'')

[快溜]

declare @name varchar(1000)
set @name=''
select @name=@name+','+name from syscolumns where id=4
select @name
/*

-------------------------------------------------------------
,rowsetid,rowsetcolid,hobtcolid,status,rcmodified,maxinrowlen

[w75251455]

declare @cols varchar(1000)
set @cols=''
select @cols=@cols+','+name from syscolumns where object_name(id)='表名'
print @cols

[AcHerat]

declare @str varchar(max)
set @str = ''

select @str = @str + [name] from syscolumns where id = object_id('表名') and xtype = 'u'