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