declare @name varchar(1000) set @name='' select @name=@name+','+name from syscolumns where id=4 select @name /*------------------------------------------------------------- ,rowsetid,rowsetcolid,hobtcolid,status,rcmodified,maxinrowlen
declare @cols varchar(1000) set @cols='' select @cols=@cols+','+name from syscolumns where object_name(id)='表名' print @cols
declare @str varchar(max) set @str = ''select @str = @str + [name] from syscolumns where id = object_id('表名') and xtype = 'u'
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,'')
set @name=''
select @name=@name+','+name from syscolumns where id=4
select @name
/*-------------------------------------------------------------
,rowsetid,rowsetcolid,hobtcolid,status,rcmodified,maxinrowlen
declare @cols varchar(1000)
set @cols=''
select @cols=@cols+','+name from syscolumns where object_name(id)='表名'
print @cols
declare @str varchar(max)
set @str = ''select @str = @str + [name] from syscolumns where id = object_id('表名') and xtype = 'u'
set @str = ''select @str = @str + ',' + [name] from sys.columns
where id = object_id('表名') and xtype = 'u'select stuff(@str,1,1,'')