【附加包】
sin
sql_sysquery
False
nodeId
supersql
1
当前节点ID
false
false
SELECT
DPO.NodeName,
DPO.Tips,
DPO.ParentID,
DPO.NodeID,
(SELECT DPS.ParentID FROM PE_Nodes DPS WHERE DPS.NodeID = @nodeId) AS CurrentID
FROM
PE_Nodes DPO
WHERE
DPO.ParentID = (SELECT DPT.ParentID FROM PE_Nodes DPT
WHERE
DPT.NodeID = (SELECT DPS.ParentID FROM PE_Nodes DPS WHERE DPS.NodeID = @nodeId))
]]>