SQLSERVER分割パッチ文字列、WHILEループ出力

405 ワード

DECLARE @Items VARCHAR(1000)='148,149,150,151' --        

--    
SET @Items=@Items+',' --    “,”          
DECLARE @ItemIndex INT=CHARINDEX(',',@Items)

WHILE(@Items!=',' AND @ItemIndex>0)--     ,    
BEGIN
	PRINT LEFT(@Items,@ItemIndex-1)
	SET @Items=RIGHT(@Items,LEN(@Items)-@ItemIndex)
	SET @ItemIndex=CHARINDEX(',',@Items)
END
--