原帖: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