InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:44:44 GMT20http://www.sqlservercentral.com/Forums/Topic692801-283-1.aspxHere is sample for Books online that uses XQuery methods[code]DECLARE @x xml-- Replace "!" with " ", as the code formatting eats up the XML SET @x='!Root> !row id="1">!name>Larry!/name>!oflw>some text!/oflw>!/row> !row id="2">!name>moe!/name>!/row> !row id="3" /!!/Root>'SELECT T.c.query('.') AS resultFROM @x.nodes('/Root/row') T(c)SELECT T.c.value('name[1]', 'VARCHAR(100)' ) AS result, T.c.value('oflw[1]', 'VARCHAR(100)' ) AS result FROM @x.nodes('/Root/row') T(c)[/code]Edit:Replaced the existing XML to non XMLWed, 08 Apr 2009 08:59:32 GMTRamesh Saivehttp://www.sqlservercentral.com/Forums/Topic692801-283-1.aspx[color=green]Dear all, Please help me,I have a Log.Dat file which is from ArcView software. Inside the Log.Dat file like XML code: [/color]How can I import the fields "Time", "type", "code", "target" ... etc in to SQL database?Please help.Wed, 08 Apr 2009 01:10:25 GMTyoothasak1