Monday, February 20, 2012

loading xml file with sp_xml_preparedocument

is it possible to load a file containing xml data with
sp_xml_preparedocument.
In SQL Server 2000: Yes, if you read the file in an ADO/OLEDB program and
pass the content to a stored proc.
In SQL Server 2005: Yes, use OpenROWSET(BULK)
Best regards
Michael
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:990d01c433c3$ffe2f600$a101280a@.phx.gbl...
> is it possible to load a file containing xml data with
> sp_xml_preparedocument.

No comments:

Post a Comment