本文实例讲述了sql Server实现将特定字符串拆分并进行插入操作的方法。分享给大家供大家参考，具体如下：
0
Begin
Set @idx = Charindex(',',@UserList);
--只有一条数据
If @idx = 0 and Len(@UserList) > 0
Begin
Insert Into BIS_MsgCenterInfo(ID,MsgID,UserID,[State])Values(Newid(),@ID,@UserList,0);
Break;
End
--多条数据
If @idx > 1
Begin
Insert Into BIS_MsgCenterInfo(ID,[State]) Values(Newid(),left(@UserList,@idx - 1),0);
Set @UserList = right(@UserList,Len(@UserList) - @idx);
End
Else
Set @UserList = right(@UserList,Len(@UserList) - @idx);
End
原文链接：https://www.f2er.com/mssql/62810.html