您的位置: 首页  >  IT文章  >  tsql 循环id读取

tsql 循环id读取

分类: IT文章 • 2023-11-29 15:31:49 
declare @IDList as varchar(max)
declare @ID as int 
declare @i as int
set @IDList=''

select @IDList=@IDList + cast(id as varchar(50)) + ',' from table
while CharIndex(',',@IDList)<>0
Begin
    set @ID = SubString(@IDList,1,CharIndex(',',@IDList)-1)
    print(@ID)
    
    set @IDList = Replace(','+@IDList,','+Cast(@ID as nvarchar(50))+',','')
End

相关推荐