用语句生成语句吧,sql server2005环境下、 declare @str varchar(8000) set @str='' select @str=@str+name+',' from sys.columns where object_id=object_id('表名') and name'列名' select @str='select '+left(@str,len(@str)-1)+' from 表名' exec(@str) sql server 2000环境下, declare @str varchar(8000) set @str='' select @str=@str+name+',' from syscolumns where id=object_id('表名') and name'列名' select @str='select '+left(@str,len(@str)-1)+' from 表名' exec(@str)
