SQL Server實(shí)現(xiàn)將特定字符串拆分并進(jìn)行插入操作的方法

--循環(huán)執(zhí)行添加操作
declare @idx as int
While Len(@UserList) > 0
Begin
  Set @idx = Charindex(',', @UserList);
  --只有一條數(shù)據(jù)
  If @idx = 0 and Len(@UserList) > 0
Begin
Insert Into BIS_MsgCenterInfo(ID,MsgID,UserID,[State])Values(Newid(),@ID,@UserList,0);
Break;
End
--多條數(shù)據(jù)
  If @idx > 1
Begin
Insert Into BIS_MsgCenterInfo(ID,MsgID,UserID,[State]) Values(Newid(),@ID,left(@UserList, @idx - 1),0);
Set @UserList = right(@UserList, Len(@UserList) - @idx);
End 
  Else
    Set @UserList = right(@UserList, Len(@UserList) - @idx);
End