M
momo
Is there a way to import an XML file into a database like MSSQL or MS Access
using ASP.NET?
using ASP.NET?
I
Ivan Demkovitch
SQL Server has support for parsing XML.
You just need to pass your XML string to stored procedure as TEXT
You just need to pass your XML string to stored procedure as TEXT
M
momo
Can you please explain how to do this?
Thanks,
Momo
Thanks,
Momo
I
Ivan Demkovitch
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
@_iXML is TEXT type input parameter for storedprocedure)
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