亚洲免费不卡_在线视频精品_国产尤物精品_久久久久网址_久久精品91_欧美va天堂在线_狠狠入ady亚洲精品_亚洲午夜精品福利_国产精品草草_午夜精品久久99蜜桃的功能介绍

sql數(shù)據(jù)庫存在父級、子級聯(lián)用的遞歸，具體代碼如下：

----------------------------------------------------------------------------

--sql 數(shù)據(jù)庫遞歸---在數(shù)據(jù)庫存在級聯(lián)用到，例如商品的父類和子類之間所屬關(guān)系

----------------------------------------------------------------------------

WITH T AS ( SELECT

* ,

lv = 0 ,

struct = CAST(id AS NVARCHAR) --struct 獲取的數(shù)據(jù)包含它本身和它的上級節(jié)點(diǎn)

FROM

tb_accounttype

WHERE

pid = 0

UNION ALL

SELECT

a.* ,

lv = ( b.lv + 1 ) ,

struct = CAST(CAST(b.struct AS NVARCHAR) + ','

+ CAST(a.id AS NVARCHAR) AS NVARCHAR)

FROM

tb_accounttype a

JOIN T b ON a.pid = b.AccountTypeNo

)

SELECT

*

FROM T

-- 如果需要加入條件查詢例如查詢name等于你需要查詢的數(shù)據(jù)則加入一下代碼即可

-- where T.name LIKE '%00%'

OPTION

( MAXRECURSION 0 )

更多信息請查看IT技術(shù)專欄