Knowledge Base

Support WebCast: Programming ADO SQLXML to Execute SQLXML Queries

Article ID: 324669

Article Last Modified on 8/2/2006

APPLIES TO

Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q324669

Session Summary

The objective of this session is to introduce Visual Studio developers to the basics of using ADO in Microsoft Visual Studio 6.0 and ASP applications to access SQL Server data as XML by executing SQLML queries. You will learn about the underlying architecture of using ADO to execute SQLXML queries. Code walkthroughs will be presented to illustrate how to execute different types of SQLXML queries (FOR XML AUTO, Templates, Updategrams, XPath queries against annotated mapping schemas, and applying an XSLT transformation to the result generated when you execute a SQLXML query) using ADO. The code samples presented in the slides of this presentation will be written using Visual Basic 6.0. The presentation will not cover the basics of XML (and its related standards XSLT, Path, DOM, and the concept of XML parsers and XSD schemas) and SQLXML. Knowledge of these topics and familiarity with Visual Basic 6.0 and ASP development will be assumed.

This is a Level 200 session that was recorded June 6, 2002 and presented by Karthik Ravindran. Karthik has been with Microsoft for more than two years. He is a Developer Support Professional in the XML Web Database team, and currently functions as the PSS MSXML Product lead. He holds a master's degree in Information Technology, and both the MCSD and the MCP+SB (Site Builder) certifications.

Viewing the Presentation

To view, please click on the link: [javascript:fnViewMMC('http://support.microsoft.com/servicedesks/webcasts/seminar/shared/asp/view.asp?url=/servicedesks/webcasts/en/wc060602/manifest.xml'); View this Support Webcast] (Length: 1 hour 22 minutes)

'

This Windows Streaming Media archive requires an Internet connection of 28.8 Kbps or faster, and is best viewed with a minimum screen resolution of 800 X 600.