文章分类 -  SQL

SqlServer的递归查询 也就是 with cte查询
摘要：表结构表数据SQL如下with lmenu as( select name,id,1 as lv,cast(Name as nvarchar(max)) as name1, cast(ROW_NUMBER()over(order by getdate()) as nvarchar(10)) as o... 阅读全文
posted @ 2015-04-17 12:56 N1900 阅读(274) 评论(0) 推荐(0)