定义自定义表值函数（split），用于分隔字符串

SELECT * FROM dbo.split('581::579::519::279::406::361::560',':') where a <> ''

create Function [dbo].[Split](@Sql varchar(8000),@Splits varchar(10))  
returns @temp Table (a varchar(100))  
As  
Begin  
Declare @i Int  
Set @Sql = RTrim(LTrim(@Sql))  
Set @i = CharIndex(@Splits,@Sql)  
	While @i >= 1  
		Begin  
			Insert @temp Values(Left(@Sql,@i-1))  
			Set @Sql = SubString(@Sql,@i+1,Len(@Sql)-@i)  
			Set @i = CharIndex(@Splits,@Sql)  
		End 
	If @Sql <> ''  
		Insert @temp Values (@Sql)  
		Return  
End