OpenXML

Using OpenXML Part II

  • Article

XML is becoming more and more prevalent in applications and more SQL Server DBAs are learning to work with this data structure. Raj Vasant brings us part 2 of his series on using OPENXML inside SQL Server, looking at passing XML into your stored procedures this time.

2006-02-16

8,362 reads

Using OpenXML

  • Article

SQL Server 2000 added XML support awhile back, though it was limited in what is offered and can be a little confusing. SQL Server 2005 will add many more features and functions, but in the meantime, if you are looking to add some XML support to your 2000 server, new author Raj Vasant brings us some basics on using OpenXML.

4.5 (2)

2007-02-23 (first published: )

40,450 reads

Blogs

Using SQL Compare for One Procedure

By

A customer recently was concerned about the time to run SQL Compare for a...

Daily Coping 11 June 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure SQL Database – Secondary Database and Tiers

By

On the theme of failover groups let’s do a quick recap on my environment....

Read the latest Blogs

Forums

Tracking, Privacy, and Lots of Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking, Privacy, and Lots of...

CU 24 patching issue.

By EasyBoy

We are having an issue applying CU24 patches on SQL 2017. The version of...

what condition case when related to portion key mean ?

By ahmed_elbarbary.2010

I work on sql server 2012 I don't understand condition below do this condition...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Write-Debug

See possible answers