|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Thursday, September 24, 2009 8:32 PM
Points: 14,
Visits: 54
|
|
[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.
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 3:33 AM
Points: 2,551,
Visits: 2,412
|
|
Here is sample for Books online that uses XQuery methods
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 result
FROM @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)
Edit:
Replaced the existing XML to non XML
--Ramesh
|
|
|
|
