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

Articles with tag XML Rss

Search for any content tagged xml

<< Newer    Items 41 to 60 of 208    Older >>

Using XML to pass lists as parameters in SQL Server

Every so often, the question comes up on forums of how to pass a list as a parameter to a SQL procedure or function. Phil Factor provides some examples using XML, and tests them against other popular methods.  Read more...
By Additional Articles 2012/01/26 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 3,856 reads

Incorporating XML into your Database Objects

XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check constraints, computed columns and defaults. Views and table-valued functions can be used to provide a tabular view of XML data that can be used in SQL Expressions. Robert Sheldon explains how.  Read more...
By Additional Articles 2012/01/20 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 2,462 reads

XML-XSL Transformations in SQL Server

With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.  Read more...
By Cem Güler 2012/01/04 | Source: SQLServerCentral.com | Category: mds
Rating: |  Discuss |   Briefcase | 3,152 reads

The XML Methods in SQL Server

The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and attributes within XML have been so foreign to the SQL language as to be somewhat of a barrier to their use. Fortunately, Robert Sheldon has once more managed to make the subject accessible to those of us who just need to get the job done.  Read more...
By Additional Articles 2012/01/03 | Source: SimpleTalk | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 3,613 reads

Managing Data Dictionaries in DW and DSS Database Applications

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.  Read more...
By Frank A. Banin 2011/12/20 | Source: SQLServerCentral.com | Category: bi
Rating: |  Discuss |   Briefcase | 5,548 reads

Working with the XML Data Type in SQL Server

The XML data type, introduced in SQL Server 2005, is a powerful construct. When used wisely, it can provide useful extensions to SQL Server. Robert Sheldon, in the first part of a series, describes how create and index a XML column in a table, and discusses when you should consider using an XML data type.  Read more...
By Additional Articles 2011/12/02 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 3,258 reads

XML Configuration files in SQL Server Integration Services

Package configuration files are a great way of providing the values of SSIS package properties so that packages can be used in a far more versatile way. They make the deployment of SSIS packages easier and can provide parameters that are based on the server configuration, or which change for each runtime. They're easy to understand, especially when explained by Rob Sheldon.   Read more...
By Additional Articles 2011/08/25 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 2,677 reads

SQL Peer-to-Peer Dynamic Structured Data Processing Collaboration

Unstructured and XML semi-structured data is now used more than structured data. But fixed structured data still keeps businesses running day in and day out, which requires consistent predictable highly principled processing for correct results. For this reason, it would be very useful to have a general purpose SQL peer-to-peer collaboration capability that can utilize highly principled hierarchical data processing and its flexible and advanced structured processing to support dynamically structured data and its dynamic structured processing. This flexible dynamic structured processing can change the structure of the data as necessary for the required processing while preserving the relational and hierarchical data principles. This processing will perform freely across remote unrelated peer locations anytime and transparently process unpredictable and unknown structured data and data type changes automatically for immediate processing using automatic metadata maintenance.  Read more...
By Additional Articles 2011/06/21 | Source: Other | Category: soa
Rating:  Rate this |   Briefcase | 2,301 reads

SQL Transparent Hierarchical Processing of Relational, XML and IMS Data

The SQL-92 standard introduced the LEFT Outer Join operation which offers a powerful alternative to standard relational processing to perform full hierarchical processing naturally and inherently. This enables SQL to transparently integrate relational data with XML, IMS and other forms of legacy hierarchical data. This can also allow the so far overlooked integration of IMS and legacy data with the Internet and XML, and visa versa.   Read more...
By Additional Articles 2011/04/15 | Source: Other | Category: xml
Rating:  Rate this |   Briefcase | 3,402 reads

XQuery for the Non-Expert – @Variable Use

Talk to the Experts In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert...  Read more...
By StrateSQL 2011/01/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,612 reads

Loading XML Data into SQL Server (SQL Spackle)

Learn how to load data in an XML file into a table in SQL Server.  Read more...
By Wayne Sheffield 2013/05/31 (first published: 2011/01/03) | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 19,764 reads

Working with null values in SQL XML

We all know NULL values must be dealt with carefully in T-SQL, but how exactly do you best deal with them in SQL XML?  Read more...
By Richard Rozema 2010/10/26 | Source: SQLServerCentral.com | Category: null
Rating: |  Discuss |   Briefcase | 6,731 reads

Sending multiple rows to the Database from an Application: Part II

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.  Read more...
By Mohd Nizamuddin 2010/10/22 (first published: 2009/08/25) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,921 reads

Sending multiple rows to the Database from an Application: Part I

New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.  Read more...
By Mohd Nizamuddin 2010/10/15 (first published: 2009/08/18) | Source: SQLServerCentral.com | Category: comma seperated
Rating: |  Discuss |   Briefcase | 27,286 reads

Scripts to use XML to insert and update rows in a SQL Server table

The following production code is what I used for inserting and updating database tables using XML as the input. These scripts are for processing data for any table to insert or update data. The support functions provided, retrieve the table schema with their data types, functions to deal with XML dates, primary keys of the table and what fields can be updated. The following article breaks down this process from beginning to end.  Read more...
By Additional Articles 2010/10/06 | Source: MSSQLTips.com | Category: xml
Rating:  Rate this |   Briefcase | 4,704 reads

Sending scheduled SQL query results via HTML e-mail using SSIS

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...
By Paul Clancy 2010/09/03 (first published: 2008/04/23) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 53,697 reads

SQL Server 2008 Table Valued Parameters Performance

An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.  Read more...
By Scott Zurolo 2010/07/08 | Source: SQLServerCentral.com | Category: tvp
Rating: |  Discuss |   Briefcase | 9,594 reads

XML Workshop 26 – SELECT * FROM XML

This article presents a generic function that makes it easy to query XML documents  Read more...
By Jacob Sebastian 2010/06/30 | Source: SQLServerCentral.com | Category: xquery
Rating: |  Discuss |   Briefcase | 12,027 reads

Generating a Distinct Delimited List Using XML

Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.  Read more...
By Puja Shah 2010/06/29 | Source: SQLServerCentral.com | Category: for xml path
Rating: |  Discuss |   Briefcase | 7,274 reads

Creating XML in SQL Server

XML has become a common form of representing and exchanging data in today's information age. SQL Server introduced XML-centric capabilities in SQL Server 2000. That functionality has been expanded in later releases. One aspect of working with XML is creating XML from relational data, which is accomplished utilizing the FOR XML clause in SQL Server.   Read more...
By Additional Articles 2010/06/22 | Source: Database Journal | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 4,393 reads
<< Newer    Items 41 to 60 of 208    Older >>