Goal: Using the following XML, insert three node records in the node table and then three two subnode records into the subnode table with a reference to the correct parent node. The node table uses a GUID as the node key.
Other News
Troubleshooting SQL Server Jobs
(Alexander Chigrik) If you have problems with SQL Server jobs, review this troubleshooting checklist to find potential solutions.
Creating a Sequence Flush in SQL Server 2000
(Eli Leiba) This user-defined in-line T-SQL function for SQL Server 2000 creates an in-memory sequence flush 1,2,3….N where N is a natural number with a value less than 1000. If N needs to be greater than 1000, the function can be modified to satisfy this as well. (script)
Connect to Text Files with the Microsoft Jet ODBC Text Driver
(Steve Kass) SQL Server provides several solutions for importing and exporting text files. Data transformation services (DTS) supports text as a data source or destination; the bcp and osql utilities can import and export text files; and T-SQL provides BULK INSERT for importing text. Another solut
Tutorial Series: Oracle XML Parser Techniques
This series of tutorials answers some frequently-asked questions about using the XML Parser for Java v2, part of the XDK for Java. Oracle XML Developer’s Kit (XDK) contains XML component libraries and utilities that you can use to XML-enable applications and Web sites. Oracle provides XML parsers
DB2 Universal Database for Windows High Availability Support Using Microsoft Cluster Server – Overview
(Aslam Nomani and Lan Pham) DB2 Universal Database (UDB) is the industry’s first multimedia, Web-ready relational database management system, strong enough to meet the demands of large corporations and flexible enough to serve medium-sized and small e-businesses. DB2 Universal Database combines inte
HOW TO: Use the Encoding Property with System.Xml Classes in Visual C# .NET
This step-by-step article explains how to use the Encoding property with XML in .NET Framework. The encoding declaration in the XML declaration identifies the encoding format of the XML data. In the System.Xml namespace, the Encoding property of the classes identifies the encoding format.
Translating Procedural Statements Between Oracle and SQL Server
(Kevin Kline) This white paper is intended to give you a QUICK but thorough overview of the issues you may encounter when translating procedural code, such as stored procedures or user-defined functions, between Oracle’s PL/SQL and Microsoft SQL Server’s Transact-SQL procedural extensions to the ANS
XML and Databases
(Ronald Bourret) This paper gives a high-level overview of how to use XML with databases. It describes how the differences between data-centric and document-centric documents affect their usage with databases, how XML is commonly used with relational databases, and what native XML databases are and
Data Extraction and Archiving in Large and Complex Environments
(David Schipper and Richard J. Bolesta) Database Administrators (DBAs) face two growing trends: database growth and database complexity. As a database grows, the ability to properly manage the database becomes increasingly complex and time consuming. Performance issues are more difficult to