OPENXML

Posted Date: 28 Nov 2008	Resource Type: Code Snippets	Category: SQL
Author: Arun Jacob	Member Level: Gold
Rating:	Points: 4

We can parse XML Docuements from SQl using queries.For that we can use OPENXML.
Before that we use an sp named sp_xml_preparedocument.



EXEC sp_xml_preparedocument @doc OUTPUT, @doc

SELECT     EmployeeID,EmployeeName
FROM       OPENXML (@doc, '/EmployeeList/Employee')
           WITH 
                    ( 
                      EmployeeID  varchar(10),
                      EmployeeName varchar(150)
                    )

We can even use INNER JOIN or many other queries on OPEN XML.

For bulk data updation or insertion this query is very useful to parse the input XML Data.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

OPENXML .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Date time function
	Previous Resource: Simple stored procedure for insertion
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

More Resources