一句话似乎不太容易搞定,以下是我写的一段sql语句 declare @name varchar(100),@sql varchar(1000) set @name='' select @name=@name+','+name from syscolumns where id=(select id from sysobjects where name='A')and (name like'%open%' or name=''scode) set @name=stuff(@name,1,1,'') set @sql='select '+@name+' from ieos01h' exec(@sql)