SQLServerCentral.com Content tagged XML, T-SQL

XML to Relational

Fri, 27 Jan 2012 07:00:00 UT

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

XML-XSL Transformations in SQL Server

Wed, 04 Jan 2012 07:00:00 UT

With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.

XML

Thu, 01 Dec 2011 07:00:00 UT

Stored procedure to script tables, has many options

Tue, 01 Feb 2011 07:00:00 UT

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.

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

Fri, 22 Oct 2010 06:00:00 UT

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.

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

Fri, 15 Oct 2010 06:00:00 UT

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.

SQL Server 2008 Table Valued Parameters Performance

Thu, 08 Jul 2010 06:00:00 UT

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.

Another way to get a table list from a string

Tue, 15 Jun 2010 06:00:00 UT

I prepared this version (my original did not used XML) By being helped by forums feedback from SQL central Forward it to yours peers.

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

Wed, 30 Dec 2009 07:00:00 UT

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.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

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

Fri, 22 Oct 2010 06:00:00 UT

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.

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

Fri, 15 Oct 2010 06:00:00 UT

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.

Using the FOR XML Clause to Return Query Results as XML

Thu, 11 Jun 2009 06:00:00 UT

The FOR XML clause in SQL Server causes a lot of difficulty, mainly because it is rather poorly explained in Books-on-Line. We challenged Bob Sheldon to make it seem simple. Here is his sublime response.

XML Index

Fri, 19 Sep 2008 06:00:00 UT

Checking XML indexs with a sample.

Sales Order Workshop Part IV

Thu, 05 Apr 2007 06:00:00 UT

In the fourth installment of this series, Jacob Sebastian moves on to SQL Server 2005 and the new XML capabilities that make working with XML data easier than ever.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Sales Order Workshop Part III

Tue, 03 Apr 2007 06:00:00 UT

In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server 2000 database. In this part, he expands upon the processing to access that data from multiple nodes.

Sales Order Workshop Part II

Thu, 29 Mar 2007 06:00:00 UT

In part 2 of this series, Jacob Sebastion continues looking at XML in SQL Server 2000 with some advanced XML processing.

Saving a Sales Order Part 1

Tue, 27 Mar 2007 06:00:00 UT

How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000.

Reducing Round Trips Part 4

Fri, 23 Apr 2004 06:00:00 UT

The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!

Replacing BCP with SQLBulkLoad

Mon, 21 Jul 2003 06:00:00 UT

New Author! Stephan writes about why he thinks the bulk load capabilities added in the SQLXML3 addition are a great way to handle imports - maybe so good that you'll stop using BCP.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Review of SQL 2000 Fast Answers

Fri, 18 Apr 2003 06:00:00 UT

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Querying XML files using SQL 2000

Fri, 11 Oct 2002 06:00:00 UT

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!

Creating Stored Procedure Documentation with XML, SQL-DMO and XSLT

Fri, 09 Aug 2002 06:00:00 UT

This article introduces TSQLDoc, a Windows Script Host script that extracts procedure metadata and embedded documentation comments from Transact-SQL stored procedures, generates XML documentation for every stored procedure in a database and optionally transforms the XML document into HTML or other format using XSLT.

Reducing Round Trips - Part 2

Wed, 06 Feb 2002 07:00:00 UT

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!

BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server

Mon, 28 Jan 2002 07:00:00 UT

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.

XML Data Solutions

Fri, 18 Jan 2002 07:00:00 UT

This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.

SQLXML 2.0 (XML for SQL Server 2000)

Mon, 29 Oct 2001 06:00:00 UT

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.