原帖:http://blog.youkuaiyun.com/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