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

Articles with tag xml Rss

Search for any content tagged xml

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

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,110 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,519 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,349 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,878 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,253 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,416 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 | 52,475 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,461 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 | 11,907 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,162 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,218 reads

SQL Server and the XML Data Type : Data Manipulation

The introduction of the xml data type, with its own set of methods for processing xml data, made it possible for SQL Server developers to create columns and variables of the type xml. Deanna Dicken examines the modify() method, which provides for data manipulation of the XML data stored in the xml data type via XML DML statements.  Read more...
By Additional Articles 2010/06/08 | Source: Database Journal | Category: xml
Rating:  Rate this |   Briefcase | 2,996 reads

Hello SSIS World, From XML!

This article brings us an SSIS package that reads an XML file and sequentially displays each XML record in a MessageBox before inserting it into a staging table. You can use this to get XML data into your SQL Server database for further processing.  Read more...
By Stan Kulp 2010/04/13 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 9,319 reads

XML Workshop 25 - Inserting elements and attributes to an XML document

This article from MVP Jacob Sebastian looks at the modify method for changing an XML document.  Read more...
By Jacob Sebastian 2010/03/18 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 7,147 reads

Ten Problems with XQuery and the SQL/XML Standard

XQuery and SQL/XML standard are processors for XML. SQL/XML was designed to try to match the capabilities of XQuery as closely as possible and XQuery was designed not only to support XML, but also to support relational processing. Read on to learn why this may have a negative influence on their capabilities.  Read more...
By Additional Articles 2010/03/02 | Source: Database Journal | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,362 reads

Using T-SQL to Transform XML Data to a Relational Format

More and more data is being stored or transmitted in an XML format. New author Nasir Mirza brings us an article that examines how to transform a number of XML structures into different relational formats for storage in SQL Server.  Read more...
By Nasir Mirza 2009/12/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,596 reads

Using XML to pass and return values to procs

Tips on parsing and sculpting XML from within a SQL 2005 stored procedure  Read more...
By Steve McRoberts 2009/10/19 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 9,965 reads

Sparse Columns ā€“ ConvertSVtoXML & XMLToResv

Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. Iā€™d venture that those serve to convert back/forth from XML storage.  Read more...
By Andy Warren 2009/10/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 775 reads

Explore XML Data Type in SQL Server

SQL Server 2005 and 2008 provide native XML data type and provides extensive support for XML data processing. The easy conversion from XML to a relational table provides a way for set-based updates based on user input.   Read more...
By Additional Articles 2009/10/01 | Source: Database Journal | Category: xml
Rating:  Rate this |   Briefcase | 3,642 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,878 reads
<< Newer    Items 41 to 60 of 199    Older >>