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

Content with tags XML, SQL Server 2005 Rss

<< Newer    Items 21 to 26 of 26   
 

I've Got the XML - Now What?

Getting a result set of XML is the easy part, but what about exporting the data in a human readable format? Most DBAs don't spend a lot of time formatting XML output, but it doesn't hurt to know how. New author David McKinney brings us a technique for generating an XML article and then using SSIS and XSL to transform it into an HTML page.   Read more...
By David McKinney 2007/02/21 | Source: SQLServerCentral.com | Category: xsl
Rating: |  Discuss |   Briefcase | 10,130 reads

SQL Server 2005: Intro to XQuery

Longtime SQL Server expert Michael Coles brings us the second part of his his introductory look at XML in SQL Server 2005 with a short examination of XQuery, the way in which you can write queries on XML data.   Read more...
By Michael Coles 2007/02/20 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 21,466 reads

Shred XML data with XQuery in SQL Server 2005

Tim Chapman discusses new functionality in SQL Server 2005 that allows you to shred XML data into a relational format without the intensive memory operations. He also explains how using XQuery rather than OPENQUERY can lead to performance gains.  Read more...
By Additional Articles 2007/02/20 | Source: Builder.com | Category: openxml
Rating:  Rate this |   Briefcase | 3,487 reads

SQL Server 2005 Integration Services - Part 42 - XML Task continued

Marcin Policht continues his discussion of various types of actions that can be performed using XML Control Flow task, focusing this month on the operation type called XPATH.  Read more...
Rating:  Rate this |   Briefcase | 2,056 reads

SQL 2005: Enter XML

SQL Server 2005 has greatly expanded the capabilities of SQL Server in many different areas. One of those that has matured greatly is the integration of XML data inside SQL Server. Longtime writer and guru Michael Coles brings us the first part of a two part series on XML ion SLQ Server 2005.   Read more...
By Michael Coles 2007/02/19 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 13,129 reads

XML Indexing In SQL Server 2005

Intrested in how to index XML documents? Here's a 12 page PDF on how this works.  Read more...
By Additional Articles 2005/05/04 | Source: Other | Category: sql server 2005
Rating:  Rate this |   Briefcase | 4,156 reads
<< Newer    Items 21 to 26 of 26   
 
Tags
miscellaneous (3)    
integration services (ssis) (2)    
namespaces (2)    
openxml (2)    
xsl (2)    
bcp (1)    
bulk insert (1)    
development (1)    
etl (1)    
performance tuning (1)    
security (1)    
sql server 7 (1)    
stored procedures (1)    
strategies (1)    
t-sql (1)