Email Alerts
-
Date defends relational model
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. Article | 02 Mar 2005
-
An introduction to XML shredding for SQL Server
It's critical to understand the effects XML shredding can have on your database environment before selecting a particular shredding approach. Tip
-
Processing XML files with SQL Server functions
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. Tip
-
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
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... Tip
-
Create a computed column in SQL Server using XML data
In this tip, SQL Server expert Robert Sheldon demonstrates how to create a function that runs the XQuery expression and then use that function within your computed column definition. Tip
-
Create DDL table in SQL Server 2005 to audit DDL trigger activity
Each time DDL statements in SQL Server 2005 make changes with commands, such as CREATE TABLE and ALTER, the DDL trigger fires an event. It's possible to log these events with an audit table and custom-made DDL trigger. In this tip, SQL Server expert ... Tip
-
Retrieve XML data values with XQuery in SQL Server 2005
When you want to access specific XML data values -- instead of XML as a single data type value -- the XQuery is the scripting language you're looking for. Microsoft designed XQuery specifically to access XML data in SQL Server 2005, allowing you to r... Tip
-
XML data type in SQL Server 2005 vs. VARCHAR (MAX)
When choosing to use the XML data type or the VARCHAR (MAX) data type, in SQL Server 2005, DBAs and developers should know the potential performance impact of each. Here's a look at two tables, one inserted and queried with XML and the other with the... Tip
-
Try the XML View Mapper
What it gives you, what it can do. Tip
-
SQL Server support for XML
New clause that allows easy data manipulation. Tip
-
SQL Server 2000 and XML
A look at some of SQL Server 2000's integrated XML support. Tip
- See more Tips on XML in SQL Server
-
How to display the XML result of 'Select For XML Explicit'
Ask the Expert
-
Transferring SQL Server data into XML format
Ask the Expert
-
XQuery
XQuery is a specification for a query language that allows a user or programmer to extract information from an Extensible Markup Language (XML) file or any collection of data that can be XML-like. Definition
-
Commerce XML (cXML or Commerce Extensible Markup Language)
Commerce XML (cXML) is a standard for the online exchange of business transaction information in common formats. Definition
-
An introduction to XML shredding for SQL Server
It's critical to understand the effects XML shredding can have on your database environment before selecting a particular shredding approach. Tip
-
Processing XML files with SQL Server functions
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. Tip
-
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
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... Tip
-
Create a computed column in SQL Server using XML data
In this tip, SQL Server expert Robert Sheldon demonstrates how to create a function that runs the XQuery expression and then use that function within your computed column definition. Tip
-
Create DDL table in SQL Server 2005 to audit DDL trigger activity
Each time DDL statements in SQL Server 2005 make changes with commands, such as CREATE TABLE and ALTER, the DDL trigger fires an event. It's possible to log these events with an audit table and custom-made DDL trigger. In this tip, SQL Server expert ... Tip
-
Retrieve XML data values with XQuery in SQL Server 2005
When you want to access specific XML data values -- instead of XML as a single data type value -- the XQuery is the scripting language you're looking for. Microsoft designed XQuery specifically to access XML data in SQL Server 2005, allowing you to r... Tip
-
XML data type in SQL Server 2005 vs. VARCHAR (MAX)
When choosing to use the XML data type or the VARCHAR (MAX) data type, in SQL Server 2005, DBAs and developers should know the potential performance impact of each. Here's a look at two tables, one inserted and queried with XML and the other with the... Tip
-
XQuery
XQuery is a specification for a query language that allows a user or programmer to extract information from an Extensible Markup Language (XML) file or any collection of data that can be XML-like. Definition
-
Commerce XML (cXML or Commerce Extensible Markup Language)
Commerce XML (cXML) is a standard for the online exchange of business transaction information in common formats. Definition
-
How to display the XML result of 'Select For XML Explicit'
Ask the Expert
- See more All on XML in SQL Server
About 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.