select * from TeachingDirectory where ParentTDID in (
select top 1 TDID from TeachingDirectory where ParentTDID='20575' )这条语句我希望他执行10次,第一次的ID是我给的人后他后面10次根据TDID这个ID来查找,然后给出结果怎么写求
select top 1 TDID from TeachingDirectory where ParentTDID='20575' )这条语句我希望他执行10次,第一次的ID是我给的人后他后面10次根据TDID这个ID来查找,然后给出结果怎么写求
(
select top 1 TDID,ParentTDID,lvl=0 from TeachingDirectory where ParentTDID='20575'
UNION ALL
SELECT a.*,lvl+1 FROM TeachingDirectory a JOIN t b ON a.ParentTDID=t.TDID
)
SELECT TDID FROM t WHERE lvl<10
(
select xxx from xxx
union all
select xxx from xxx
) select * from ta
什么意思
select top 1 TDID from TeachingDirectory where ParentTDID='20575' )这条语句的结果有的DownTDID这个字段我需要这个字段的结果来查询下个,结果是我10次的查询的结果
;WITH t AS
(
select top 1 TDID,ParentTDID,lvl=0 from TeachingDirectory where ParentTDID='20575'
UNION ALL
SELECT a.TDID,a.ParentTDID,lvl+1 FROM TeachingDirectory a JOIN t b ON a.ParentTDID=t.TDID
)
SELECT TDID FROM t WHERE lvl<10
无法绑定由多个部分组成的标识符 "t.TDID"。是什么意思我SQL太白痴了