摘要:
ALTER FUNCTION [dbo].[UFun_SqlSplit] (@Str varchar(120),@Sp varchar(120))RETURNs @table TABLE( ID int IDENTITY PRIMARY KEY, value nvarchar(max) )BEGIN/*Test:select * from SqlSplit('123,234',',')*/IF LEN(@Str)<1return;DECLARE @pos intDECLARE @temppos intSET @pos =0;WHILE(CHARINDEX( 阅读全文