tsql 循环id读取
2015-10-10 17:09:53

declare @IDList as varchar(max)declare @ID as int declare @i as intset @IDList=''select @IDList=@IDList + cast(id as varchar(50)) + ',' from tablewhile CharIndex(',',@IDList)<>0Begin set @ID = SubString(@IDList,1,CharIndex(',',@IDList)-1) print(@ID) ......

本文摘自 ：https://www.cnblogs.com/