sql-server - 将 Oracle sql "CONNECT BY LEVEL"转换为 T-SQL

Question

谁能帮忙把下面的sql转换成T-SQL吗？

SELECT *
FROM (    SELECT LEVEL n, TO_DATE ('31/12/2010', 'DD/MM/YYYY') + NUMTODSINTERVAL (LEVEL, 'day') CurrDate
          FROM DUAL
    CONNECT BY LEVEL <= 2000);

Answer 1

我认为这应该可以解决问题

select dateadd(d, number, '2010-12-31') 
from master..spt_values 
where type='p' 
and number between 1 and 2000