String'i split eden fonksiyon

fn$_GetSplitedString

-- String'i split eden fonksiyon
CREATE FUNCTION fn$_GetSplitedString 
(
	@seperator CHAR(1)
	, @stringList NVARCHAR(MAX) 
)
RETURNS @returnTable TABLE
(
	TagName NVARCHAR(100) NOT NULL
)
AS
BEGIN
	DECLARE 
		@listLength BIGINT
		, @nextTagName NVARCHAR(100)
		, @index BIGINT
		, @startIndex BIGINT


	SET @listLength = LEN(@stringList)
	SET @index = 1
	SET @startIndex = 1

	WHILE @index < @listLength
	BEGIN
		SET @index = CHARINDEX(@seperator, @stringList, @index)
		
		IF(@index = 0)
		BEGIN 
			SET @index = @listLength
		END

		SET @nextTagName = SUBSTRING(@stringList, @startIndex, @index - @startIndex)

		SET @startIndex = @index + 1
		SET @index = @startIndex

		INSERT INTO @returnTable SELECT @nextTagName
	END
	
	RETURN
END
GO