Tag: XML

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 XML Problems

Troubleshooting SQL Server 2012 XML Problems If you have problems with SQL Server 2012 XML, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server service pack. Because some SQL Server 2012 XML bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Oracle Pro Members Standard Members

Querying Relational Data With XQuery

Querying Relational Data With XQuery By Yuli Vasiliev This article illustrates how you might query relational data with Oracle XQuery. It also shows how you might join relational data with XML in a single SQL query, thus demonstrating the Oracle Database’s ability to work with and combine together different format data. In the following example, you query the DEPARTMENTS and...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Oracle Pro Members Standard Members

Database Tables Holding Data in Oracle XML DB Repository

Database Tables Holding Data in Oracle XML DB Repository By Yuli Vasiliev This article illustrates how you might query the XMLType tables that hold the data available via Oracle XML DB Repository. In particular, you’ll look at how you might optimize XQuery queries that use functions fn:doc and fn:collection to reference the repository data, accessing the underlying storage tables directly...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

XML Support and SQL Server (Part 5)

XML Support and SQL Server (Part 5) By Basit A. Farooq Editor’s Note: This article is the fifth part of my XML support and SQL Server article series. In this part, I’ll discuss the basic XML queries and data manipulation. I’ll also give the brief introduction to the XQuery language and the use of query(), value(), exist(), nodes(), and modify()...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Oracle Pro Members Standard Members

Joining Relational Data and XML Data In a SQL Query

Joining Relational Data and XML Data In a SQL Query In this article, you’ll look at how you might merge external XML data into an Oracle database and then join that XML data with relational data stored inside the database within a single SQL query. To follow the article sample, you’ll first need to create an XML document to be...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members Standard Members XML

XML Support and SQL Server (Part 3)

XML Support and SQL Server (Part 3) By Basit A. Farooq This article is the third part of the XML support and SQL Server article series. In this part, I’ll first talk about what fundamental problems we have in integration XML and SQL Server. Then, I’ll cover what storage options we have in SQL Server to store the XML data...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2012 XML Optimization Tips

SQL Server 2012 XML Optimization Tips Consider using the XML data type. This data type is used to store XML documents in table columns or Transact-SQL variables. The XML data type can be used in variables, columns, or in stored procedure and function parameters. You can build, rebuild or drop XML indexes online. In SQL Server 2012, indexes that include...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members Standard Members XML

XML Support and SQL Server (Part 2) – XML Schemas

XML Support and SQL Server (Part 2) – XML Schemas By: Basit A. Farooq XML schemas Although, it is possible to create an XML document that follows no formal structure if the document (or fragment) is for internal or your own use. However, this isn’t recommended. Because, as we all know, working without a formal design often leads to a...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

XML Support and SQL Server (Part 1)

XML Support and SQL Server (Part 1) By Basit A. Farooq XML fundamentals Beginning with SQL Server 2005, Microsoft improved and expanded its eXtended Markup Language (XML) support, the activities that previously required complementary products now have native support. Native XML commands and utilities have been expanded to include new features. In this article, I’ll give you an overview of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting xml problems in SQL Server 2008 R2

Troubleshooting xml problems in SQL Server 2008 R2 If you have problems with xml in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 xml bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register