列名和行數定義成變量,然後寫動態sql declare @n int declare @fields varchar(100) set @n=10 set @fields='name,id,xtype' exec('select top '+@n+' '+@fields+' from sysobjects')
select 列1, 列2, 列3 from table
--id为连续的自增列 select * from (select * from #t where [id] % 3=2)a left join (select * from #t where [id] % 3=1) b on a.id=b.id-1 left join (select * from #t where [id] % 3=0) c on b.id=c.id-1
declare @n int
declare @fields varchar(100)
set @n=10
set @fields='name,id,xtype'
exec('select top '+@n+' '+@fields+' from sysobjects')
select * from (select * from #t where [id] % 3=2)a left join
(select * from #t where [id] % 3=1) b on a.id=b.id-1 left join
(select * from #t where [id] % 3=0) c on b.id=c.id-1