declare @sql varchar(8000),@col varchar(8000) set @col='' select @col=@col+[name]+',' from sys.columns where object_id=object_id('tb_test') and is_identity<>1 set @col=left(@col,len(@col)-1) --去掉最后1个逗号 set @sql='select '+@col+' from tb_test' exec (@sql) --把tb_test换成你的表名试试?是这意思?
declare @sql varchar(8000),@col varchar(8000)
set @col=''
select @col=@col+[name]+',' from sys.columns where object_id=object_id('tb_test') and is_identity<>1
set @col=left(@col,len(@col)-1) --去掉最后1个逗号
set @sql='select '+@col+' from tb_test'
exec (@sql)
--把tb_test换成你的表名试试?是这意思?