Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags XML, Basics Rss

   Items 1 to 20 of 31    Older >>
 

XML IN 20 MINUTES!

This article will quickly dive head first right into XML.   Read more...
By Leon Platt 2008/01/04 (first published: 2003/09/26) | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 184,180 reads

ASP.NET 2.0: Retrieving XML Data with XmlDataSource Control

This article shows how to retrieve both remote and local XML data and display it in a data Web control.  Read more...
By Additional Articles 2007/09/10 | Source: 4 Guys From Rolla | Category: basics
Rating:  Rate this |   Briefcase | 3,342 reads

XML Workshop V - Reading Values from XML Columns

Continuing on with his series on XML in SQL Server 2005, Jacob Sebastian brings us more examples on how to delve into the values of XML data.   Read more...
By Jacob Sebastian 2007/08/22 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 9,425 reads

Retrieving Data as XML from SQL Server

All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically-structured format.  Read more...
By Additional Articles 2007/02/23 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 3,330 reads

Some Usages for XML

While SQL Server 2005 has greatly expanded the XML capabilities of the platform, many DBAs are still not familiar with or comfortable with using XML in their coding. Yousef Ekhtiari brings us a new article that looks at a basic use of XML in inserting data into a table.   Read more...
By Yousef Ekhtiari 2007/02/22 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 7,205 reads

SQL Server 2005 – DML Usage on an untyped XML column

Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.  Read more...
By Additional Articles 2006/09/18 | Source: Database Journal | Category: basics
Rating:  Rate this |   Briefcase | 1,613 reads

Making Sense of the XML DataType in SQL Server 2005

n SQL Server 2005, XML becomes a first-class data type. Developers can make minor remote modifications to stored XML documents easily, taking advantage of new support for XML schema-based strong typing, and server-based XML data validation.   Read more...
By Additional Articles 2006/07/10 | Source: DevX | Category: basics
Rating:  Rate this |   Briefcase | 2,724 reads

Using XQuery to Manage XML with SQL Server 2005

XML is now becoming more widely used as wireless devices are becoming more secure, and new technologies such as XQuery for SQL Server 2005 are making it much easier to handle XML more efficiently at the server level. Jesse Smith gives you a crash course on XQuery methods and how you can use them in certain situations to retrieve and update XML data stored in your SQL Server 2005 database.  Read more...
By Additional Articles 2006/05/18 | Source: InformIT | Category: basics
Rating:  Rate this |   Briefcase | 2,825 reads

Using XQuery, New Large DataTypes, and More

SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification with XQuery, and the new XML datatype.  Read more...
By Additional Articles 2006/05/08 | Source: MSDN Communities | Category: basics
Rating:  Rate this |   Briefcase | 2,351 reads

Constructing XML Using FOR XML

A SELECT query returns results as a rowset. You can optionally retrieve formal results of a SQL query as XML by specifying the FOR XML clause in the query.  Read more...
By Additional Articles 2006/04/19 | Source: MSDN Communities | Category: basics
Rating:  Rate this |   Briefcase | 2,944 reads

Introduction to XQuery in SQL Server 2005

This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features. Non-supported features of XQuery in SQL Server 2005 and workarounds are described in this article. It also presents three scenarios where XQuery is useful.   Read more...
By Additional Articles 2005/06/23 | Source: MSDN Communities | Category: basics
Rating:  Rate this |   Briefcase | 2,557 reads

XML Simplified

Everyone should be aware that XML is supported in SQL Server 2000 and plays an integral part of not only SQL Server 2005, but all of the Windows family. IIS metadata, web services, etc. all involve XML. But do you know what XML is and how to work with it? Author Raj Vasant brings us a basic article on what XML is and how the documents are structured.   Read more...
By Vasant Raj 2005/05/23 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 13,006 reads

XML IN 20 MINUTES!

This article will quickly dive head first right into XML.   Read more...
By Leon Platt 2008/01/04 (first published: 2003/09/26) | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 184,180 reads

Methods for Parsing XML files

Jon shows you several ways you can parse XML.   Read more...
By Jon Winer 2004/10/01 (first published: 2002/06/20) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,278 reads

A Survey of Microsoft SQL Server 2000 XML Features

An oldy, but good basic look at XML and how it fits into SQL Server 2000.   Read more...
By Additional Articles 2004/09/23 | Source: MSDN Communities | Category: basics
Rating:  Rate this |   Briefcase | 2,881 reads

Handling Simple XML Using T-SQL

SQL Server 2000 integrates a number of features to work with XML data and SQL Server 2005 should expand upon that. However the SQL Server 2000 extensions for working with XML data in T-SQL are not that mature. New author Eli Leiba looks at how he can traverse an XML file using T-SQL code.   Read more...
By Eli Leiba 2004/09/20 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 12,880 reads

Reducing Round Trips Part 4

The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!   Read more...
By Andy Warren 2004/04/23 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,949 reads

XML IN 20 MINUTES!

This article will quickly dive head first right into XML.   Read more...
By Leon Platt 2008/01/04 (first published: 2003/09/26) | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 184,180 reads

Querying XML files using SQL 2000

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!   Read more...
By David Poole 2002/10/11 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 11,871 reads

Converting Shaped Recordsets into XML

This article shows you how to take a shaped recordset and convert the results into XML all while preserving the shaped recordset hierarchy.   Read more...
By Jon Winer 2002/08/08 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 5,742 reads
   Items 1 to 20 of 31    Older >>
 
Tags
miscellaneous (6)    
programming (6)    
t-sql (6)    
sql server 7 (5)    
ado (3)    
news (3)    
openxml (3)    
updategrams (3)    
visual basic 6 (3)    
asp (2)    
performance tuning (2)    
advanced querying (1)    
database design (1)    
monitoring (1)    
schemas/dtds (1)    
xsl (1)