SQL Server implements the method of splitting and inserting a particular string _mssql

The example in this article describes how SQL Server implements splitting and inserting specific strings. Share to everyone for your reference, specific as follows:

--Loop execution Add action
declare @idx
as int while Len (@UserList) > 0
Begin
  Set @idx = Charindex (', ', @UserList); c5/>--only one piece of data
  if @idx = 0 and Len (@UserList) > 0
Begin Insert into
bis_msgcenterinfo (id,msgid,userid,[ State]) Values (Newid (), @ID, @UserList, 0);
break;
End
-Multiple data
  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

I hope this article will help you with your SQL Server database program.