Importing XML into SQL Server 2000 1 Comment
Importing XML into SQL Server 2000 using a number of different methods: # Using MSXML 4 DOM & ADO # Using MSXML 4 SAX & ADO # Using SQLXML 3.0 Bulk Load # Using OPENXML and ADO # Using .NET DataSet Class # DTS ActiveX Script & SQLXML 3.0 Bulk Load # DTS ActiveX Script [...]
Populating DB from XML using a stored procedure Comment
This is an article/example of how to use a stored procedure to populate a DB (SQL Server 2000) from XML. http://www.codeproject.com/cs/database/insxmldatasqlsvr.asp This explains the sp_xml_preparedocument and sp_xml_removedocument system stored prcoedure of SQL Server 2000 http://msdn.microsoft.com/library/default.asp?url=… Using SQL Server’s XML Support – SQL Server is an XML-enabled DB, which can read and write XML data, return [...]
