|
你的图画的不好啊,我用GraphViz生成的就是看得出来,呵呵
先生成路径
with
A (n) As
(
Select 1
Union All
Select n + 1 From A Where n < 4
),
V0 (S, L, C) As
(
Select Cast(n As Varchar(Max)) S, n L, 1 C From A
Union All
Select S + Cast(n As Varchar(Max)), n, C + 1 From V0, A
Where Abs(L - n) = 1 And C <= 4
),
V (S) As (Select S From V0 Where C = 4),
R (F, T, GV) As
(
Select VF.S, VT.S, VF.S + '->' + VT.S From V VF, V VT
Where SubString(VF.S, 2, Len(VT.S) - 1) = SubString(VT.S, 1, Len(VT.S) - 1)
)
Select * From R Order By F
|
-
r.png
(78.46 KB, 下载次数: 42)
图
-
-
r.txt
353 Bytes, 下载次数: 4
gv文件
|