Monthly Archives: May 2006

Load xml file by OPENROWSET

In SQL 2000, a long expected feature is to load an xml file and use sp_xml_xx procedures and OPENXML to shred the data into relational tables. SQL 2005 implemented this feature by the BULK provider for OPENROWSET. OPENROWSET supports bulk … Continue reading

Posted in SQL server 2005 | Leave a comment