SQLServerCentral.com Content tagged XML, T-SQL, Basics

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!

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!

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.

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!

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.

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.