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
动态表头创建实例
最新推荐文章于 2024-06-16 19:33:59 发布