Sign In
XQuery Inside SQL Server 2005
Hopefully helpful postings, articles and walkthroughs for people using XQuery inside SQL Server 2005.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Pages
Archive
Archives
November 2005
(1)
October 2005
(2)
September 2005
(1)
August 2005
(4)
July 2005
(2)
June 2005
(3)
May 2005
(6)
April 2005
(6)
May, 2005
MSDN Blogs
>
XQuery Inside SQL Server 2005
>
May, 2005
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
XQuery Inside SQL Server 2005
Efficient Property Promotion from XML Instances
Posted
over 7 years ago
by
Mike Rorke
4
Comments
In many cases, when storing XML data, some of the elements/attributes will be more important for storage/querying than others. Access to values inside XML data-type instances requires additional overhead when compared with just selecting relational data...
XQuery Inside SQL Server 2005
Adding a Style-sheet Declaration to your XML Output
Posted
over 7 years ago
by
Mike Rorke
0
Comments
A common requirement for formatting XML output from XQuery expressions, is to be able to add a style-sheet declaration. Style-sheet declarations consist of a standard processing-instruction node that appears at the top-level of the XML. In the following...
XQuery Inside SQL Server 2005
MSDN Webcast on using XQuery in SQL Server 2005
Posted
over 7 years ago
by
Mike Rorke
0
Comments
Michael Rys (a program manager for XML technologies in SQL Server 2005) recently gave a webcast for MSDN where he covers some of the details of the new native XML data type. He gives details of basic usage, static typing, DML and indexing. Michael also...
XQuery Inside SQL Server 2005
New links section for whitepapers
Posted
over 7 years ago
by
Mike Rorke
0
Comments
I have added a new section under my links that points to useful whitepapers dealing with XQuery and/or XML inside SQL Server 2005. These articles contain a lot of useful details on the system and I would recommend that everyone using (or planning on using...
XQuery Inside SQL Server 2005
Good Introduction to Using XML in SQL Server 2005
Posted
over 7 years ago
by
Mike Rorke
1
Comments
I just reviewed the web cast of a presentation given by one of our program managers here in the SQL Server XML team. It gives a good overview of the various features of our native XML data type, including insertion, indexing, DML and schema binding. If...
XQuery Inside SQL Server 2005
De-entitizing Special XML Characters
Posted
over 7 years ago
by
Mike Rorke
2
Comments
There are several tricky issues around the serialization of special XML characters inside SQL Server 2005. This was highlighted to me earlier today when I had a question about how to output a URL value that caontains an ampersand (' & ') character...
Page 1 of 1 (6 items)