Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to split and insert a specific string by SQL Server". In the daily operation, it is believed that many people have doubts about how to split and insert a specific string with SQL Server. The editor has consulted all kinds of materials and sorted out simple and useful operation methods. I hope it will be helpful for you to answer the question of "how can SQL Server split a specific string and insert it?" Next, please follow the editor to study!

The example of this article describes the method of SQL Server implementation to split and insert a specific string. Share with you for your reference, the details are as follows:

-- add operation declare @ idx as intWhile Len (@ UserList) > 0Begin Set @ idx = Charindex (',', @ UserList);-- there is only one data If @ idx = 0 and Len (@ UserList) > 0BeginInsert Into BIS_MsgCenterInfo (ID,MsgID,UserID, [State]) Values (Newid (), @ ID,@UserList,0); Break End-- multiple data If @ idx > 1BeginInsert 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 at this point, on the "SQL Server how to split a specific string and insert operation," the study is over, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.