SQL Server 2005递归查询
时间：2022-03-10 17:21
WHIT XXX(列1,列2....) AS
( SELECT
列1,列2... FROM
表WHERE ID=xxxxxx UNION
ALL SELECT
列1,列2.... FROM
表 WHERE ID = XXX.ParentID)SELECT 列1，列2.... FROM
XXX |
SQL Server 2005递归查询,布布扣,bubuko.com
