动态表头创建实例

原帖：http://blog.csdn.net/htl258/archive/2009/04/03/4047624.aspx

 

declare @sql as varchar(1000)
declare @i as int
set @i = 0
set @sql = 'create table tb ('
while @i <= 10
begin
  set @sql = @sql +
  '[' + convert(varchar(10),dateadd(day , @i , getdate()),120) + '] int ,'
  set @i = @i + 1
end
set @sql = left(@sql , len(@sql) - 1) + ') select * from tb'
exec(@sql)

/*
2009-04-03 2009-04-04  2009-04-05  2009-04-06  2009-04-07  2009-04-08  2009-04-09 2009-04-10  2009-04-11  2009-04-12  2009-04-13
---------------------- ----------- ----------- ----------- ----------- ---------------------- ----------- ----------- -----------

(0 行受影响)
*/

drop table tb