SQL inserts the field values separated by commas (,) into the table cyclically.

Insert the field values separated by a single character into the table cyclically
Declare @ strchatrooms nvarchar (1000) -- custom parameter, value containing the ',' symbol
Declare @ userid int -- custom Parameter
Declare @ tmpnum int -- check ',' character, move position
Declare @ tmpid int -- get the separated values for inserting the table
Declare @ isuccess int -- a viewing error is returned.

Begin tran
-- Case string
Set @ strchatrooms = '11, 12,13, 14,15 ,'
-- Initialization check ',' symbol position, symbol custom
Set @ tmpnum = 1
-- Inserts data separated by commas (,) into the information table cyclically.
While Len (@ strchatrooms)> 0
Begin
If substring (@ strchatrooms, @ tmpnum, 1) = ','
Begin
Set @ tmpid = cast (left (@ strchatrooms, @ tmpNum-1) as INT)
Set @ strchatrooms = right (@ strchatrooms, Len (@ strchatrooms)-@ tmpnum)
Set @ tmpnum = 1
Insert into chatadmin (userid, chatroomid) values (@ userid, @ tmpid)
If @ error <> 0
Begin
Rollback tran
Set @ isuccess =-14
Return
End
End
Else
Set @ tmpnum = @ tmpnum + 1
End
Commit tran