The objective of this XML Schema is to improve the dissemination of road works and other highways related information between local government, central government, emergency services and the media with an e-GIF compliant XML schema. The XML Schema defines a message to serve parties that send and/or receive information about a Road Event or Road Work. The message details the current state of an event. The message can describe potential future events, by indicating start time and end time.

Learn guidelines for XML data modeling and usage in SQL Server 2005, and see illustrative examples.

XML offers exceptional performance advantage over other ways of exchanging data. Want to know more? In this article, Baya Pavliashvili gives you a brief overview of XML components, and introduces you to Transact-SQL XML extensions.

Improve performance and gain convenience by using custom business objects serialized to and from XML rather than forcing your presentation-tier developers to work directly with DataSets.

This is a small faq which shows how you can exchange data via XML updategrams.

Get to know the main features of SQL Server Reporting Services and learn how to extend it with an XML Data Provider Extension.

When data needs to be exchanged between distributed systems, transformed to target multiple devices, or converted into other data structures, XML provides a very flexible and extensible medium. Accessing relational data as XML can be useful in a variety of situations.

This article discusses the XML support built into SQL Server 2005. It shows how this support integrates with the client side programming support in the .NET Framework V2.0 and in native code such as OLEDB and SQLXML.

Discover the many different ways SQL Server 2000 supports XML with a comprehensive look at both out-of-the-box support and the SQLXML 3.0 add-on.

ASP.NET provides powerful capabilities for engineering highly scalable web portals for businesses. The newly released SQLXML 3.0 enables convenient access to data from SQL Server 2000 databases with the data delivered as XML. XSL files can be applied to transform the delivered XML into dynamically-generated web pages and portions of web pages contained within <div> elements, or the XML can be delivered to an ASP.NET XML control.

Microsoft's SQLXML 3.0 includes many different aspects, including Managed Classes, capability for accessing SQL Server 2000 using IIS virtual directories, and support for templates, updategrams, and diffgrams. This article focuses on the advanced SQLXML features, and shows how to develop an ASP.NET application that uses SQLXML to access and modify SQL Server tables using virtual directories, templates, and updategrams.

SQLXML allows developers to bridge the gap between XML and relational data. Using SQLXML you can create XML View of your existing relational data and work with it as if it was an XML file. In comparison with SQL Server 2000's native XML, the SQLXML 3.0 has many features (such as XML bulk load, updategrams, XSD mapping schemas and so on) and provides better performance.

SQL Server is an XML-enabled DBMS, which can read and write XML data, return data from databases in XML format, and read and update data stored in XML documents. In fact, SQL Server has eight different ways to use XML. Learn how each of them works, and how they interoperate.

The next version of SQL Server will have a significant amount of functionality related to storing, querying and extracting XML from the database. To accompany the information being imparted at TechEd 2004, myself and rest of the folks behind the XML Developer Center on MSDN decided to run a series of articles on the XML features of SQL Server 2005. The articles will run through the month of June. The first article in the series is XML Support in Microsoft SQL Server 2005. Read this article if you are interested in learning how SQL Server 2005 has become a fully XML-aware database including the addition of the XML datatype, support for XML Schemas, indexing of XML data, XQuery, querying XML views of relational data using XPath and much more.

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.

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.

Microsoft has recently started embracing Extensible Markup Language (XML), but embracing XML is different from putting it natively into a product. SQL Server administrators and database developers haven't missed full integration of XML in SQL Server, but they've now come to realize that they needed XML all along. In the next version of SQL Server, XML output will be a standard option, letting you create a channel of information-including information pulled directly from the SQL Server-that you can pass to other systems. If you combine XML and Data Transformation Services (DTS), bulk copy program (bcp) will continue to slip out of use, to the delight of most database developers and administrators.

XML is fast becoming the lingua franca of the new technology world the universal markup language you can use to represent any other language running on any platform. Although SQL Server 2000 is the first SQL Server release to provide integrated XML support, Microsoft's XML technology preview, available at http://msdn.microsoft.com/downloads/default.asp?URL=/code/topic.asp?URL=/msdn-files/028/000/072/topic.xml, runs under any SQL Server release. The technology preview, refined through 11 revisions, is robust, and many SQL Server installations are using it to integrate XML and SQL Server.

Our company uses SQL Server 7.0 and 6.5 for our largest databases and Microsoft Access 2000 for our smaller databases. Using Visual Basic (VB) applications, we've been successfully exchanging data between SQL Server-based databases and Access-based databases. How can we achieve this required heterogeneous connectivity by using ADO with XML?