General information
Forum:
Microsoft SQL Server
We need to import data from a XML file into a table of sql server database.
As I know, we could use OPENXML. Could we use other methods?
Could we read directly from a XML file instead of using @doc like in following example?
DECLARE @idoc int
DECLARE @doc varchar(1000)
SET @doc ='
....
'
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
SELECT *
FROM OPENXML
EXEC sp_xml_removedocument @idoc
Thanks
Jim Hou
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only