摘要: 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 阅读全文
posted @ 2013-12-20 13:54 被谋杀的诗篇 阅读(518) 评论(0) 推荐(0) 编辑