This is piece of SP I have:(@_iXML is TEXT type input parameter for stored
procedure)
DECLARE @Answers Table (SurveyDetlKey Int NOT NULL,
SurveyKey Int NULL)
-- assume failure
SELECT @_oRetVal = 0
EXEC sp_xml_preparedocument @XMLDoc OUTPUT, @_iXML
INSERT @Answers (SurveyDetlKey)
SELECT SurveyDetlKey FROM OPENXML (@XMLDoc , '/ROOT/Array', 1 )
WITH (SurveyDetlKey INT) AS tAnswers
EXEC sp_xml_removedocument @XMLDoc
Reed SQL Server Books Online for descriptions of sp_xml_preparedocument
Hope it helps
"momo" <se**********@seeourweb.com> wrote in message
news:OM*************@tk2msftngp13.phx.gbl...
Can you please explain how to do this?
Thanks,
Momo
"Ivan Demkovitch" <i@a.b> wrote in message
news:OI**************@TK2MSFTNGP11.phx.gbl... SQL Server has support for parsing XML.
You just need to pass your XML string to stored procedure as TEXT
"momo" <se**********@seeourweb.com> wrote in message
news:uD**************@TK2MSFTNGP10.phx.gbl... Is there a way to import an XML file into a database like MSSQL or MS
Access using ASP.NET?