sql插入问题
给定起始日期和终止日期，怎样向表中字段插入起始日期和终止日期之前的日期
如起始日期 2012-01-01 终止日期 2012-01-05
那么想得到数据库表A中结果如下
2012-01-01
2012-01-02
2012-01-03
2012-01-04
2012-01-05
最好不要用循环方式，能一次给加入数据最好
------最佳解决方案--------------------

DECLARE @i DATETIME

DECLARE @j DATETIME



SET @i = '2012-01-01'

SET @j = '2012-06-01'





SELECT  CONVERT(date, DATEADD(dd, number, @i)) AS dd

FROM    master..spt_values

WHERE   DATEADD(dd, number, @i) BETWEEN @i AND @j

        AND type = 'P'

        

        

/*

2012-01-01

2012-01-02

2012-01-03

2012-01-04

2012-01-05

2012-01-06

2012-01-07

2012-01-08

2012-01-09

2012-01-10

2012-01-11

2012-01-12

2012-01-13

2012-01-14

2012-01-15

2012-01-16

2012-01-17

2012-01-18

2012-01-19

2012-01-20

2012-01-21

2012-01-22

2012-01-23

2012-01-24

2012-01-25

2012-01-26

2012-01-27

2012-01-28

2012-01-29

2012-01-30

2012-01-31

2012-02-01

2012-02-02

2012-02-03

2012-02-04

2012-02-05

2012-02-06

2012-02-07

2012-02-08

2012-02-09

2012-02-10

2012-02-11

2012-02-12

2012-02-13

2012-02-14

2012-02-15

2012-02-16

2012-02-17

2012-02-18

2012-02-19

2012-02-20

2012-02-21

2012-02-22

2012-02-23

2012-02-24

2012-02-25

2012-02-26

2012-02-27

2012-02-28

2012-02-29

2012-03-01

2012-03-02

2012-03-03

2012-03-04

2012-03-05

2012-03-06

2012-03-07

2012-03-08

2012-03-09

2012-03-10

2012-03-11

2012-03-12

2012-03-13

2012-03-14

2012-03-15

2012-03-16

2012-03-17

2012-03-18

2012-03-19

2012-03-20

2012-03-21

2012-03-22

2012-03-23

2012-03-24

2012-03-25

2012-03-26

2012-03-27

2012-03-28

2012-03-29

2012-03-30

2012-03-31

2012-04-01

2012-04-02

2012-04-03

2012-04-04

2012-04-05

2012-04-06

2012-04-07

2012-04-08

2012-04-09

2012-04-10

2012-04-11

2012-04-12

2012-04-13

2012-04-14

2012-04-15

2012-04-16

2012-04-17

2012-04-18

2012-04-19

2012-04-20

2012-04-21

2012-04-22

2012-04-23

2012-04-24

2012-04-25

2012-04-26

2012-04-27

2012-04-28

2012-04-29

2012-04-30

2012-05-01

2012-05-02

2012-05-03

2012-05-04

2012-05-05

2012-05-06

2012-05-07

2012-05-08

2012-05-09

2012-05-10

2012-05-11

2012-05-12

2012-05-13

2012-05-14

2012-05-15

2012-05-16

2012-05-17

2012-05-18

2012-05-19

2012-05-20

2012-05-21

2012-05-22

2012-05-23

2012-05-24

2012-05-25

2012-05-26

2012-05-27

2012-05-28

2012-05-29

2012-05-30

2012-05-31

2012-06-01*/

------其他解决方案--------------------

declare @begintime datetime

declare @endtime datetime

set  @begintime='2012-01-01'

set  @endtime='2012-01-05'



;with f as

(

select @begintime as dt

union all

select dateadd(dd,1,dt) from f where dat