sqlserver里循环调用

发布时间：2020-12-12 14:12:34 所属栏目：MsSql教程来源：网络整理

导读：declare @T1 Int select @T1=Pm_PListID from PmLists? where Pm_ListID=684 while exists(select 1 from PmLists where Pm_listid=@T1 and Pm_PListID0) ? begin ? select @T1=Pm_PListID from PmLists? where Pm_ListID=@T1 ? end select @T1 as TmpField

declare @T1 Int

select @T1=Pm_PListID from PmLists? where Pm_ListID=684
while exists(select 1 from PmLists where Pm_listid=@T1 and Pm_PListID>0)
? begin
? select @T1=Pm_PListID from PmLists? where Pm_ListID=@T1
? end

select @T1 as TmpField

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!