Monthly Archives: May 2006

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 →