This tutorial will show you the different methods of retrieving XML from SQL Server, how to control how the data is returned, and then discuss how to navigate through the returned results. You will also learn ways of viewing SQL Server tables from an XML perspective. From there you’ll learn how to load data into SQL Server using XML natively, including real-time over HTTP.

In my opinion, one of the most annoying things about some websites is logging in. Today, Mitchell will demonstrate how to create a nifty little feature that will allow your site to "remember" its visitors.

In this article Mitchell shows us how to develop a simple ad campaign and management system using ASP and an SQL Server database.

Stored procedures are a feature of popular database management systems such as Oracle and Microsoft SQL Server 2000. This article will give you a quick overview of stored procedures and how to pass parameters to them from ASP.

When we're querying a database, we will usually need to press a submit button on a form to pass data to another ASP page, which would generate the query, and return the results. In some situations, this page refresh is just plain annoying and takes too long to complete. In this article, Phanix will describe another way to query a database using a combination of web technologies.

Using Microsoft SQL Server 2000 and some ASP script, Mitch creates a function that will ping any remote server, digest and process the results, and then return a summary of that ping session through an ASP function.

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. In this article, Mitchell will show us how SQL Server 2000 incorporates XML support using the "FOR XML EXPLICIT" method to retrieve data from a table as a customised XML document.

ASP allows even the newest developer to connect to databases with ease. In fact, the ease with which you can connect to a wide range of databases from within an ASP script is one of the reasons why ASP has become so popular. In this article Joe teaches us how to connect to SQL Server 2000 using system DSN's and an OLEDB connection string.

Data Transformation Services (DTS) were added to SQL Server 7 and allow us to combine several data-related tasks into one common object. In this article Tim shows us how to create a DTS package with SQL Server 2000 that will access a database and email the results of a query to some sales executives. He also shows us how to execute and error trap DTS packages from within an ASP script.

In part one of this two-part article Annette, show us how to create an ASP class that allows us to work with our databases through a web browser. It will allow us to update and delete records dynamically using JavaScript and XMLHTTP, without ever having to refresh the page.

In this article Annette wraps up the details of the real time data grid that she started to describe in part one of this two-part article. She looks at the JavaScript code that contacts our database server and allows us to update data in a database without actually refreshing the page.

You've got a database containing information about employees in your company, and want to provide a search interface. The only problem? People are searching for terms like Mike, and no results are being returned because it's stored as Michael in the database. Ideally, you'd like to return results that sound like Mike, but how can you do this? (4Guys)

XDR is anacronym for XML-Data Reduced and is a language used to create schemas. Normally a Data Type Definition (DTD) is used to describe the structure of the data in an XML document. This is generally fine, except that in the DTD and XML document all data is character data.

To help reduce the amount of data that needs to be entered into the URL we can use <B>XMLtemplates</B>. XML templates are simply XML files that contain the query string or stored procedure to be executed.

This article demonstrates how to build a reusable database administration page using database-level information found in SQL Server's system-level tables. Since the administration page relies on the database to provide information regarding the database tables, their columns, and their data types, the developer only needs to specify information on what database to edit through the administration page! (4Guys)