Basic Search  Advanced Search   
Topics Resources Free Library Software XML News About Us
  You are here: home »» Focus »» SQLXML » Articles & Tutorials Thursday, 28 February 2008
SQLXML 3.0 SP2 Beta 1 now available!

SQL Server 2000 XML and .NET Integration (aka SQLXML)


  SQLXML Tutorials

  SQLXML KB Articles

  SQLXML Links

  SQLXML News Recommends
Professional SQL Server 2000 XML (Wrox Press)
Professional SQL Server 2000 XML

SQL Server 2000 XML Distilled
SQL Server 2000 XML Distilled

SQLXML Articles & Tutorials

Build Data-Driven Web Services with Updated XML Support for SQL Server 2000 May 2002
XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients—one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.
SQL Server 2000: New XML Features Streamline Web-centric App Development March 2000
With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By adding Internet Explorer 5.0 to the mix and using XSL to convert the XML to HTML, you can lighten the load on your database server. Going still one step further, by using Vector Markup Language you can even create drawings on the fly using the data from your SQL queries.

This article illustrates this combination of technologies by leading you through the creation of a Web app that queries a digitized street map database that’s been imported into a SQL Server database, sorts and displays the data using XML, and draws maps using VML.
A Survey of Microsoft SQL Server 2000 XML Features July 26, 2001
This article is based on the SQL Server XML functionality which is available as of the XML for Microsoft SQL Server 2000 Web Release 2 Beta 1. Since SQL Server 2000 was released in fall 2000, the WebData group at Microsoft has provided two fully supported upgrades to enhance and improve the XML features. XML for SQL Server Web Release 1 was released in February 2001, and XML for SQL Server Web Release 2 is currently available as a Beta preview and will be ready for a Web release in the fall of 2001. These frequent releases are a result of customer demand and the fast-changing world of XML standards. For example, Web Release 2 supports XSD, based on the W3C recommendation.
SQLXML and MSXML - an alternative approach to traditional data access August 2001
In this article, we'll learn how to build data driven Web applications using SQL Server's XML support in conjunction with MSXML. We will read and write SQL Server data without using ADO, ODBC, or any other data access mechanism.
Developing XML-Enabled Data Solutions for the Web January 2002
Using XML for data access allows you to separate the data from the presentation, and promotes reuse, extensibility, and division of labor. XML also has a simplified data model, which promotes easier testing.

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.
Power Up Database Apps With XML March 2002
SQL Server's enhanced XML support offers a robust technique for processing operations against database tables. Microsoft's XML support in SQL Server 2000 used to fall a ways short of the mark. However, with the release of new add-on versions of XML support for SQL Server, Microsoft has provided a powerful and often overlooked set of tools that can add scalability and power to your applications. In this article, you'll look at the XML for SQL Server 2000 Web Release 2 beta 2 (WR2) package and discover what it brings to your development toolbox. You'll build a small Visual Basic example using the XML Web release and the XMLHTTP object provided with the MSXML parser to demonstrate how you can use this release to rev up your applications.
Using SQLXML 3.0 and Visual Basic .NET to Build an Intranet Web Site April 2002
Support for Extensible Markup Language (XML) and XML features in Microsoft® SQL Server™ 2000 allows developers to build Web and enterprise database applications that function across system platforms and different programming languages. Enhancements to both XML and Microsoft .NET Framework support in SQL Server since the release of SQL Server 2000 and the addition of SOAP Web services support for SQL Server have further expanded this capability. The sample application that is described in this paper demonstrates how you can use Microsoft SQLXML 3.0 and Microsoft Visual Basic® .NET to build an extensible and scalable Web site.
Take Advantage of SQLXML with ASP.NET March 2002
Use SQLXML's Web services to access XML data directly from your ASP.NET applications. SQLXML is a set of supplemental tools that extend SQL Server's existing support for retrieving and storing XML data. With SQLXML 3.0, you are now able to use SQL Server to expose Web services. SQLXML's Web services let you execute stored procedures, user-defined functions, and they support templates.
SQL Server XML and Web Application Architecture November 2000
This article provides an overview of the resulting architectures when both the Duwamish Books, Phase 4 application and the more robust Duwamish Online application were applied in a set of SQL Server XML-based solutions.
Inside SQLXML Virtual Directory Structure February 2002
This white paper provides an orientation to XML and clarifies the role of XML documents in the future of SQL Server programmability
SQLXML Managed Classes February 2002
This white paper will explain the mechanics of using SQLXML Managed Classes for a variety of scenarios.
Simplify Data Access With SQL Server 2000's XML Support: Understand SQL Server 2000's XML support and you can develop simpler and faster. March 2002
SQL Server 2000 can both produce XML output and consume XML input, but perhaps the flashiest feature in the latest version to make use of XML is the Internet Information Services (IIS) Virtual Directory Management for SQL Server utility (see Resources). Administrators can use it to set up a virtual directory that allows users to query the database and even run stored procedures with a HTTP request. A Web browser capable of displaying XML, such as Internet Explorer 6, can view XML returned from a query entered in the URL. Queries can be either standard SQL queries with the FOR XML clause or XPath queries.
Importing XML into SQL Server 2000 February 2002
One of the frequently asked questions on SQL Server newsgroups is "How to import XML data into SQL Server 2000?" There are various ways in which XML data can be imported into SQL Server 2000 database tables. In this article, we'll look at some of these options. More specifically, we'll explore the following approaches:
  • Using MSXML 4 DOM & ADO
  • Using MSXML 4 SAX & ADO
  • Using SQLXML 3.0 Bulk Load
  • Using OPENXML and ADO
  • Using .NET DataSet Class
Using SQL Server 2000 to Build Database Applications in Visual Studio .NET February 2002
This white paper introduces the new tools and data classes, walks you through the process of building a database application, and highlights the support for new SQL Server 2000 features such as XML support, indexed views, and cascading referential integrity.
Leveraging SQL Server's XML Features (2000)
Customize XML Data with SQL Server (Jan 2001)
Part 1: Access XML data the easy way—without even using ADO
Part 2: Simplify app development with SQL Server 2000's query and data-manipulation features
In this article, the author shows additional ways that you can query and manipulate SQL Server 2000 data using FOR XML EXPLICIT queries, OPENXML, and Updategrams.
Chapter 6: XSD Schemas from the book Professional SQL Server 2000 XML August 2001
Professional SQL Server 2000 XML book is a complete and well-organized reference to learn the latest XML features introduced in SQL Server 2000 and it's XML integration Web releases. The book covers each and every detail with respect to utilizing SQL Server's XML features to build Web and Enterprise application. If you are a member or lead of any development team, and are planning to use SQL Server 2000 in your project, we recommend this book – you'll learn many new ways to build database application with very less code that is manageable and efficient.
Chapter 4: Accessing SQL 2000 via HTTP from the book XML and SQL Server 2000 July 2001
XML and SQL Server 2000 will enable SQL developers to understand and work with XML, the preferred technology for integrating eBusiness systems. These developers have realized the need to be able to understand and work with high-speed storage and generation capabilities that XML documents and data offer.
The SQLXML Provider January 2002
Microsoft recently released the second version of their SQLXML data provider. SQLXML2 is intended for use with Microsoft SQL Server 2000 and MDAC 2.6+ and Microsoft's download actually installs two providers – one for regular ADO, and a second managed .NET provider, for use with ADO.NET development. These providers are intended to assist developers who are working with data from SQL Server when it is handled as XML. Support for automatically applying XSL transformations, executing XPath queries and XML templates, along with additional DiffGram support for ADO.NET is all included in this release. In this article, Peter McMahon deals with the basics of using this provider, including installation, a basic overview of its architecture and a run–through of its basic features in both .NET and ASP.
ASPToday Subscribers only.
Inserting, joining and mining XML with SQL Server 2000's OPENXML Rowset provider September 2001
New to SQL Server 2000 is the OpenXML function, a powerful row set provider, which can take an XML string of data and turn the elements and attributes you choose into a table object. This table can be joined to other XML data, views or other tables within SQL Server 2000 or queried for specific items. In this article Ian Vink will show you how to work with this new row set provider and will demonstrate how to increase efficiencies, and optimize your network traffic and stored procedures using it.
ASPToday Subscribers only.
XML and SQL Server 2000
The way to present data in a platform independent manner is through XML. The client-cursor, SQLOLEDB provider, and SQL Server internally all provide XML support.
Expose SQL Server Stored Procedures With SQLXML 3.0 February 2002
The SQLXML Web releases provide several new features for interacting with a SQL Server 2000 database using XML technologies. SQLXML 3.0 continues to build on these features, adding the ability to expose SQL Server 2000 data using XML-based Web services. SQLXML 3.0 makes exposing SQL Server 2000 stored procedure as XML Web Services easy. And there's more good news: Those Web services are easily consumed by Visual Studio .NET client applications.
SQL Server 2000 XML Integration
XML has taken the industry by storm - not only revolutionizing the way that web pages are generated, but also the way that data is exchanged between disparate systems. This session will explain the new XML support added to SQL Server 2000. In particular, you will learn about XML recordsets, URL-based queries, XML views/schemas, and how the addition of XSLT transformations can greatly simplify the delivery of XML data to disparate targets.
Chapter 2: Retrieving XML Data Using Transact-SQL from the book Programming Microsoft® SQL Server™ 2000 with XML May 2001
Discover how to transform your organization’s relational databases into potent e-commerce, business-to-business, and Web applications with this core reference for solution developers. The rich XML support in Microsoftâ SQL Server™ 2000 makes it easy to map XML and relational data with familiar standards such as XPath, XDR schemas, XSL Transformation, HTTP, and OLE DB, as well as newer tools. You’ll learn how to retrieve XML data from the database, insert XML data into the database, and manipulate it in extensible database solutions. And you’ll examine real-world solutions—including knowledge-management systems and high-volume electronic retail databases—that demonstrate how to use SQL Server and XML to move your critical business processes to the Web. An appendix discusses XML specifics for SQL Server developers.
Powerpoint presnetation and source code from A Day of .NET (CNUG) October 2001
Download the powerpoint presentation and source code.
  Contact Us | E-mail Us | Site Guide | About PerfectXML | Advertise ©2004 All rights reserved. | Privacy