摘要:
SET NOCOUNT ONDECLARE @splitString VARCHAR(MAX) = 'ab,cd,efg, hello world!'; --需要被拆分的字符串DECLARE @separator VARCHAR(10) = ','; --分隔符DECLARE @CurrentIndex int;DECLARE @NextIndex int;DECLARE @ReturnText nvarchar(max); SET @CurrentIndex = 1;WHILE(@CurrentIndex<=len(@SplitString)) BEGI 阅读全文