XML in SQL Server

The Extensible Markup Language (XML) is geared toward documents containing structured information. SQL Server integrates with XML and provides an environment to develop enterprise applications. XML provides a way to define tags and structural relationships. The standard was created so richly structured documents could be used over the Web and likewise SQL Server. XML was designed to describe data and what data is, as opposed to the Hypertext Markup Language (HTML), which displays data and focuses on how it looks. XML was created to structure, store and send information.

In this topic:

Must read

News:

1 - 1 of 1
  • Date defends relational model 02 Mar 2005

    Article - Chris Date, a renowned proponent of the relational model, takes on SQL, XML and all things object-oriented in a fiesty keynote address at the DAMA symposium this week.

VIEW ALL News ON XML in SQL Server

Expert Technical Advice:

1 - 3 of 19
  • An introduction to XML shredding for SQL Server 01 Feb 2010

    Tip - It's critical to understand the effects XML shredding can have on your database environment before selecting a particular shredding approach.

  • Processing XML files with SQL Server functions 16 Feb 2009

    Tip - The procedure of loading XML files onto a SQL Server database and processing them into tables is not well documented. Discover a prescribed method that uses both SQL Server functions and XPath expressions.

  • Manage traces in SQL Server 2005 Analysis Services with XMLA commands 03 Jul 2008

    Tip - SQL Profiler is an efficient tool for tuning and troubleshooting Microsoft Analysis Services 2005, that is, unless you're managing numerous instances. In this tip, you'll learn how to use XMLA to automate tracing to monitor MSAS. Here's what you need to...

VIEW ALL Expert Technical Advice ON XML in SQL Server

Definitions:

1 - 2 of 2

VIEW ALL Definitions ON XML in SQL Server