How to write xml data in SqlServer

Wrox Programmer Forums

		Wrox Programmer Forums > XML > XML
How to write xml data in SqlServer

XML General XML discussions.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the XML section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

October 19th, 2004, 03:18 AM

rekha_jsr

rekha_jsr is offline

Authorized User

Join Date: Sep 2004

Posts: 60

Thanks: 0

Thanked 0 Times in 0 Posts

Default

How to write xml data in SqlServer

Hi.

I m having a XMl file and I want to write data from xml to SqlServer table.

How to doo it?

rekha

__________________
It is always safe to assume, not that the old way is wrong, but that there may be a better way...
*************************
Rekha

Old

October 21st, 2004, 12:22 PM

joefawcett joefawcett is offline

joefawcett is offline

Wrox Author

Join Date: Jun 2003

Posts: 3,074

Thanks: 1

Thanked 38 Times in 37 Posts

Default

Look on msdn.com for SQLXML, particularly OPENXML.

--

Joe (Co-author Beginning XML, 3rd edition)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How Silverlight write data to XML file?	tomalani	Other Programming Languages	0	May 15th, 2008 07:31 AM
how to write array in sqlserver	msbsam	SQL Server 2000	22	October 23rd, 2007 09:00 PM
xml invalid top level from ASP write XML(solution)	g000we	XML	0	August 9th, 2006 03:56 AM
Displaying SQLServer data to user	sss22	ASP.NET 1.0 and 1.1 Basics	1	October 28th, 2005 01:05 PM
Inserting data into Sqlserver	ksrmramu	Access ASP	1	July 28th, 2005 03:23 PM