SQLServerCentral.com Content tagged XML, Basics

XML IN 20 MINUTES!

Fri, 04 Jan 2008 07:00:00 UT

This article will quickly dive head first right into XML.

ASP.NET 2.0: Retrieving XML Data with XmlDataSource Control

Mon, 10 Sep 2007 06:00:00 UT

This article shows how to retrieve both remote and local XML data and display it in a data Web control.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

XML Workshop V - Reading Values from XML Columns

Wed, 22 Aug 2007 06:00:00 UT

Continuing on with his series on XML in SQL Server 2005, Jacob Sebastian brings us more examples on how to delve into the values of XML data.

Retrieving Data as XML from SQL Server

Fri, 23 Feb 2007 07:00:00 UT

All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically-structured format.

Some Usages for XML

Thu, 22 Feb 2007 07:00:00 UT

While SQL Server 2005 has greatly expanded the XML capabilities of the platform, many DBAs are still not familiar with or comfortable with using XML in their coding. Yousef Ekhtiari brings us a new article that looks at a basic use of XML in inserting data into a table.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

SQL Server 2005 – DML Usage on an untyped XML column

Mon, 18 Sep 2006 06:00:00 UT

Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.

Making Sense of the XML DataType in SQL Server 2005

Mon, 10 Jul 2006 06:00:00 UT

n SQL Server 2005, XML becomes a first-class data type. Developers can make minor remote modifications to stored XML documents easily, taking advantage of new support for XML schema-based strong typing, and server-based XML data validation.

Using XQuery to Manage XML with SQL Server 2005

Thu, 18 May 2006 06:00:00 UT

XML is now becoming more widely used as wireless devices are becoming more secure, and new technologies such as XQuery for SQL Server 2005 are making it much easier to handle XML more efficiently at the server level. Jesse Smith gives you a crash course on XQuery methods and how you can use them in certain situations to retrieve and update XML data stored in your SQL Server 2005 database.

Using XQuery, New Large DataTypes, and More

Mon, 08 May 2006 06:00:00 UT

SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification with XQuery, and the new XML datatype.

Constructing XML Using FOR XML

Wed, 19 Apr 2006 06:00:00 UT

A SELECT query returns results as a rowset. You can optionally retrieve formal results of a SQL query as XML by specifying the FOR XML clause in the query.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Introduction to XQuery in SQL Server 2005

Thu, 23 Jun 2005 06:00:00 UT

This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features. Non-supported features of XQuery in SQL Server 2005 and workarounds are described in this article. It also presents three scenarios where XQuery is useful.

XML Simplified

Mon, 23 May 2005 06:00:00 UT

Everyone should be aware that XML is supported in SQL Server 2000 and plays an integral part of not only SQL Server 2005, but all of the Windows family. IIS metadata, web services, etc. all involve XML. But do you know what XML is and how to work with it? Author Raj Vasant brings us a basic article on what XML is and how the documents are structured.

XML IN 20 MINUTES!

Fri, 04 Jan 2008 07:00:00 UT

This article will quickly dive head first right into XML.

Methods for Parsing XML files

Fri, 01 Oct 2004 06:00:00 UT

Jon shows you several ways you can parse XML.

A Survey of Microsoft SQL Server 2000 XML Features

Thu, 23 Sep 2004 06:00:00 UT

An oldy, but good basic look at XML and how it fits into SQL Server 2000.

Handling Simple XML Using T-SQL

Mon, 20 Sep 2004 06:00:00 UT

SQL Server 2000 integrates a number of features to work with XML data and SQL Server 2005 should expand upon that. However the SQL Server 2000 extensions for working with XML data in T-SQL are not that mature. New author Eli Leiba looks at how he can traverse an XML file using T-SQL code.

Reducing Round Trips Part 4

Fri, 23 Apr 2004 06:00:00 UT

The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!

XML IN 20 MINUTES!

Fri, 04 Jan 2008 07:00:00 UT

This article will quickly dive head first right into XML.

Querying XML files using SQL 2000

Fri, 11 Oct 2002 06:00:00 UT

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!

Converting Shaped Recordsets into XML

Thu, 08 Aug 2002 06:00:00 UT

This article shows you how to take a shaped recordset and convert the results into XML all while preserving the shaped recordset hierarchy.

Methods for Parsing XML files

Fri, 01 Oct 2004 06:00:00 UT

Jon shows you several ways you can parse XML.

CLIENT SIDE XML - ASP on steroids !

Thu, 11 Apr 2002 06:00:00 UT

This article demonstrates the ability to use the XML DOM on the client-side browser.

Microsoft XML Core Services 4.0 RTM

Fri, 05 Apr 2002 06:00:00 UT

The core components to Microsoft XML parser have been updated and released to market. The update contains many bug fixes, new features and enhancements to performance.

Reducing Round Trips - Part 2

Wed, 06 Feb 2002 07:00:00 UT

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server

Mon, 28 Jan 2002 07:00:00 UT

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.

XML Data Solutions

Fri, 18 Jan 2002 07:00:00 UT

This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.

Simple OLE DB Provider for XML

Mon, 10 Dec 2001 07:00:00 UT

The OLE DB Simple provider for XML (XML OSP) can be used to load the hierarchical data that is in an XML document into a read-only ADO recordset. The data can then be read and accessed by using the standard methods of the ADO Recordset object. The XML OSP can be used to provide a different method for working with data that is contained in XML documents.

Using SQL Server 2000 and XML to Monitor the Usage of your SMTP Server

Thu, 29 Nov 2001 07:00:00 UT

This article describes how to monitor Microsoft SMTP usage using SQL Server 2000 and XML.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

XML for SQL Server 2000: Optimizing Your Performance

Thu, 01 Nov 2001 06:00:00 UT

The XML features of Microsoft® SQL Server® 2000 and the subsequent XML for SQL Server 2000 Web releases enable a whole new class of XML-aware applications. This article shows you how to improve the performance of this new feature.

SQLXML 2.0 (XML for SQL Server 2000)

Mon, 29 Oct 2001 06:00:00 UT

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.