Read and Write XML

http://mohammedfauzi.blogspot.com/2008/10/sample-to-read-write-xml-file-throught.html
http://www.dotnetspider.com/resources/22457-c-code-for-read-write-xml-file-simple-way.aspx

Sample for table valued function , STRINGSPLITTER

Sample for table valued function

Eg :
SELECT * FROM dbo.stringsplitter('12,14,14,15,as155,1gf1,df', ',')

CREATE FUNCTION [dbo].[stringsplitter]

(

@ParamaterList VARCHAR(MAX),

@Delimiter CHAR(1)

)

RETURNS @ReturnList TABLE

(

FieldValue VARCHAR(MAX)

)

AS BEGIN

DECLARE @ArrayList TABLE

(

FieldValue VARCHAR(MAX)

)

DECLARE @Value VARCHAR(MAX)

DECLARE @CurrentPosition INT

SET @ParamaterList = LTRIM(RTRIM(@ParamaterList))

+ CASE WHEN RIGHT(@ParamaterList, 1) = @Delimiter THEN ''

ELSE @Delimiter

END

SET @CurrentPosition = ISNULL(CHARINDEX(@Delimiter, @ParamaterList, 1), 0)

IF @CurrentPosition = 0

INSERT INTO @ArrayList ( FieldValue )

SELECT @ParamaterList

ELSE

BEGIN

WHILE @CurrentPosition > 0

BEGIN

SET @Value = LTRIM(RTRIM(LEFT(@ParamaterList,

@CurrentPosition - 1))) --make sure a value exists between the delimiters

IF LEN(@ParamaterList) > 0

AND @CurrentPosition <= LEN(@ParamaterList)

BEGIN

INSERT INTO @ArrayList ( FieldValue )

SELECT @Value

END

SET @ParamaterList = SUBSTRING(@ParamaterList,

@CurrentPosition

+ LEN(@Delimiter),

LEN(@ParamaterList))

SET @CurrentPosition = CHARINDEX(@Delimiter,

@ParamaterList, 1)

END

END

INSERT @ReturnList ( FieldValue )

SELECT FieldValue

FROM @ArrayList

RETURN

END