SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags XML, SQL Server Rss

   Items 1 to 4 of 4   
 

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.  Read more...
By Diogo Castro 2018/08/07 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,029 reads

Examples of using XQuery to update XML Data in SQL Server

What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method, which makes use of three operational keyword sets: insert, replace value of, and delete. Seth Delconte takes a closer look.  Read more...
By Additional Articles 2018/07/11 | Source: MSSQLTips.com | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,334 reads

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.  Read more...
By Additional Articles 2017/09/28 | Source: SimpleTalk | Category: json
Rating:  Rate this |   Briefcase | 5,920 reads

Using XML from data variable option in SSIS

Learn how you can manipulat XML documents solely in memory. No file required.   Read more...
By Cindy Conway 2013/05/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 4,993 reads
   Items 1 to 4 of 4   
 
Tags
c# (1)    
for xml (1)    
html (1)    
integration services (ssis) (1)    
json (1)    
xquery (1)    
yaml (1)