Microsoft KB Archive/324669

= 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.

Additional Resources
Download presentationwc060602. This is a 234-KB Microsoft PowerPoint (.ppt) file.

If you do not have PowerPoint and you want a copy of the slides, use the PowerPoint Viewer (2,752 KB).

Read the transcript from this Support WebCast

[mailto:?subject=Support%20WebCast:%20Programming%20ADO%20SQLXML%20to%20Execute%20SQLXML%20Queries&body=Take%20a%20look%20at%20this%20Microsoft%20Support%20WebCast%20about%20%20Programming%20ADO%20SQLXML%20to%20Execute%20SQLXML%20Queries(June%206,%202002).%20More%20information%20about%20this%20WebCast%20is%20available%20at%20http://support.microsoft.com/WebCasts. Tell a friend about this Support WebCast]

Supplemental reading:
 * Web cast on new features in SQLXML 2.0
 * The SQLXML 3.0 SDK documentation (included with SQLXML 3.0)
 * The XML and Internet support section in the SQL Server 2000 RTM Books on line

Provide Feedback on this Broadcast

Support WebCasts Home

Keywords: kbdownload kbtshoot kbwebcastsupport kbinfo KB324669

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.