SQLSERVER分割パッチ文字列、WHILEループ出力
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
--