使用"CONNECT BY LEVEL"转换Oracle sql；到T-SQL [英] Convert Oracle sql with "CONNECT BY LEVEL" to T-SQL

问题描述

任何人都可以帮助将以下sql转换为T-SQL吗?

Can anyone help to converting following sql to 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);

推荐答案

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

This should do the trick, I think

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

这篇关于使用"CONNECT BY LEVEL"转换Oracle sql；到T-SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！