Yes it is inline function. Function returns the table.

CREATE FUNCTION hdFunction ( @XMLdata XML )

RETURNS @Datatable TABLE

(

Col1 SMALLINT

, Col2 NVARCHAR(12)

)

AS BEGIN

WITH XMLNAMESPACES ( DEFAULT 'http://abc.com', 'http://hd.com' AS a,

'http://www.w3.org/2001/XMLSchema-instance' AS i )

INSERT INTO @Datatable

SELECT T.C.value('a:data1[1]', 'smallint') AS Column1

, T.C.value('(a:data2/a:data3)[1]', 'nvarchar(12)') AS Column2

FROM @XMLdata.nodes('/XmlStart/Data/a:col1/a:col1Data') T ( C )

RETURN

END