摘要:
;with a as(select ID = 1union allselect ID + 1 from awhere ID < 50)select *From aOPTION(MAXRECURSION0)结果是50行连续的数字 option为无限制的写法,否则只能递归100次;with a as (... 阅读全文
posted @ 2015-12-24 22:37
只争朝夕
阅读(249)
评论(0)
推荐(0)


浙公网安备 33010602011771号