12 2015 档案
T-SQL 递归算法实现
摘要：;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)