Rumah > Artikel > pangkalan data > Sql Server 常用自定义函数
-- 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 ,