Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > SQLXML


Search:
What's New - What's Hot
"Column name Create Date contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault."  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: Umair Feroze      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have a stored procedure which returns data as an XML node. This stored procedure uses temp table to populate data. The column names in the temp table contain spaces, i.e. [Create Date]....

XML Data in SQL Server 2000 (ADO.NET)  Version: 0.00     Price: $0.00  
Total Hits: 22  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2000 introduced support for XML functionality when retrieving data. To enable you to return an XML stream directly from SQL Server 2000, the SqlCommand object of the .NET Framework Data Provider for SQL Server has the ExecuteXmlReader method. ExecuteXmlReader returns a System.Xml.XmlReader object populated with the results of the SQL statement specified for a SqlCommand. For more information about the XmlReader, see the XmlReader Class. ExecuteXmlReader can only be used with...

SQL XML Documentation  Version: 0.00     Price: $0.00  
Total Hits: 36  |  Today: 0Author: EJocys      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article will help to choose a proper SQL XML Documentation format for the future and help to convert these comments into Microsoft Help formats with minimal resources....

SQL Server - Retrieving the definition of an XML Schema Collection  Version: 0.00     Price: $0.00  
Total Hits: 19  |  Today: 0Author: beyondrelational.com      Rating:  
Read Reviews | Write Review |  Your Rating: 

Retrieving the definition of an XML Schema Collection from SQL Server...

Parameter Discovery on Microsoft Access With XML option. Using Microsoft Patterns and Practices     
Total Hits: 191  |  Today: 0Author: Patrickquinn1212      Rating:  
Read Reviews | Write Review |  Your Rating: 

This project contacts the Microsoft Access Jet 4.0 Database and gathers schema information that is used to build command parameters for stored procedures and SQL query commands. "Generics.cs" , which is the class that Data.dll uses for Microsoft Access, throws an exception if you try to discover parameters since this cannot be done. I added my schema collection classes to this method thereby enabling the main abstract class to continue. It adds command parameters to the internal cache (at next u...

SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web     
Total Hits: 76  |  Today: 0Author: Scott Howlett and Darryl Jennings      Rating:  
Read Reviews | Write Review |  Your Rating: 

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

Build Data-Driven Web Services with Updated XML Support for SQL Server 2000     
Total Hits: 82  |  Today: 0Author: Christian Thilmany      Rating:  
Read Reviews | Write Review |  Your Rating: 

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

SQL Server 2000 and XML     
Total Hits: 135  |  Today: 0Author: Kirk A. Evans, Ashwin Kamanna, Joel Mueller.      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2000 has several key features right out of the box that enable support for XML. Combining these features with ADO.NET and the XML Framework classes provide a broad range of options for working with data, which simplifies data access over the web.
In addition to the XML support that an out-of-the-box installation of SQL Server provides, Microsoft has also released SQLXML 3.0, a service pack to SQL Server that provides additional features to those already present in SQL Server 2000. ...

Generating Relational data from xml datatype-Part 2     
Total Hits: 324  |  Today: 0Author: Imran Nathani      Rating:  
Read Reviews | Write Review |  Your Rating: 

In Part 1 of this article, we saw the basics of the xml datatype and retrieval of data from it. In this part we will see the use of the xml datatype in relational data tables and the retrieval of data from an xml datatype in relational form. The purpose of displaying data from the xml datatype in a relational form is to apply normal ADO.NET practices and other relational data management concepts easily.
* Formation of Views from this formed relational data.
* Retrieval of this data...

Generating Relational data from xml datatype Part 1     
Total Hits: 318  |  Today: 0Author: Imran Nathani      Rating:  
Read Reviews | Write Review |  Your Rating: 

The introduction of the xml datatype in SQL Server has given us an enhancement of actually dumping raw XML obtained from different servers into a distributed environment into one relational table. This article which is the first part of two, deals with the basics of the xml datatype and retrieving data from the xml datatype. The xml datatype is normally used to store information of a more static nature like invoices, vouchers or receipts obtained from other systems in XML form. However it can al...

SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability to Admins and Users     
Total Hits: 252  |  Today: 0Author: Carl Nolan      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition. The article then concentrates on XML support, covering XML data retrieval and manipulation, queries, and HTTP...

Generating XSDs     
Total Hits: 137  |  Today: 0Author: ExtremeExperts.com      Rating:  
Read Reviews | Write Review |  Your Rating: 

In our previous article we saw how we can use XSDs in conjunction with SQLXML. But how can we generate XSDs rather than typing them separately. Here are some simple steps to achieve the same using VS .NET IDE....

Learn SQLXML in .NET Tutorial     
Total Hits: 258  |  Today: 0Author: TopXML      Rating:  
Read Reviews | Write Review |  Your Rating: 

We will investigate how we can build a business application that’s completely XML-enabled. We will look at each tier of the three tier application model and discuss our options to leverage XML in the most efficient way; not only in terms of performance, but also with respect to the development effort and code maintenance....

Interactive Microsoft SQL Server & XML Online Tutorial     
Total Hits: 367  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This tutorial will introduce you to using XML with Microsoft SQL Server 2000™ and guide you through the concepts and techniques of how to read and write data using XML with Microsoft SQL Server 2000™. You will learn the various methods used and see how powerful and flexible it is to retrieve and save data to and from Microsoft SQL Server™ using XML and the built in functionality of Microsoft SQL Server™. You will learn in the examples how to use FOR XML and OPENXML which are used to read and wri...

Working with the XML Data Type of SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 4  |  Today: 0Author: Bipin Joshi      Rating:  
Read Reviews | Write Review |  Your Rating: 

With the growing use of XML data, the need for the coexistence of relational data and XML data is also growing. The classic approach of storing XML data as physical disk files is unsuitable and tedious in many situations. No wonder modern database engines are geared to store XML documents right along with the rest of the relational data. To that end, the XML data type introduced in SQL Server 2005 is a great addition to the database engine. Prior to SQL Server 2005, developers often used VARCHAR...

Retrieving Dynamic XML from SQL Server 7.0 and 2000  Version: 0.00     Price: $0.00  
Total Hits: 5  |  Today: 0Author: Steven Wood      Rating:  
Read Reviews | Write Review |  Your Rating: 

With the introduction of tMicrosoft's XML SQL Server Technology Preview for SQL Server 7.0 and SQL Server 2000, a host of XML functionality is no available. Over the past months I have been using the Tech Preview and more recently 2000, mainly in retrieving dynamic XML Documents. This article will describe the different ways of retrieving XML documents, highlight my experiences, and list the differences between the Tech Preview and 2000. And finally I'll discuss how you can call these features f...

Read Data From XML File in SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 3  |  Today: 0Author: Lakhangarg      Rating:  
Read Reviews | Write Review |  Your Rating: 

sp_xml_preparedocument - Reads the XML text provided as input (@XMLDATA) ,
the xml text and returns a handle that can be used to access the newly created internal representation of the XML document. The output of this procedure is XML handle that is
used for OPENXML command....

SQL Server 2000: New XML Features Streamline Web-centric App Development  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

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

XSLT Processing, Processing Instructions in XML, Parameterizing Statements in XML, and More  Version: 0.00     Price: $0.00  
Total Hits: 4  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

Although XSLT only accepts XML input, there are several ways to process SQL Server 2000 results using XSLT. The simplest way is to use the XML support built into SQL Server 2000. SQL Server 2000 introduced the FOR XML clause, which allows query results to be returned as XML fragments....

Use Write Caching to Optimize High Volume Data Driven Applications  Version: 0.00     Price: $0.00  
Total Hits: 16  |  Today: 0Author: Steven Smith      Rating:  
Read Reviews | Write Review |  Your Rating: 

The typical use of caching applies to read caching, or caching data in the application to avoid reading it from the database. However, for applications that must frequently write back to the database, write caching can provide dramatic improvements to performance. This article describes how to implement write caching for an ASP.NET application. Use of SQL Server XML capabilities is also touched on....


1  2  3  4  5  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net