作者:mobiledu2502929507 | 来源:互联网 | 2018-07-10 11:51
--select*from[dbo].[SplitToTable](ADSF,|)--.(@SplitStringvarchar(max),@Separatorchar(1))((1,1),(max));;(max);;(@SplitString))(@Separator,@SplitString,@CurrentIndex);)(@SplitString)+1;(
-- select * from [dbo].[SplitToTable]('ADSF','|') -- . ( @SplitString varchar ( max ), @Separator char ( 1 )) ( ( 1 , 1 ), ( max )) ; ; ( max ); ; ( @SplitString )) ( @Separator , @SplitString , @CurrentIndex ); ) ( @SplitString ) + 1 ; (
-- select * from [dbo].[SplitToTable]('ADSF','|')
--.
(
@SplitString varchar(max),
@Separator char(1)
)
(
(1,1),
(max)
)
;
;
(max);
;
(@SplitString))
(@Separator,@SplitString,@CurrentIndex);
)
(@SplitString)+1;
();
() VALUES(@ReturnText);
;
END
RETURN;
END
,