Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

XML

1
February 8, 2010  11:00 AM

Using XMLNAMESPACES within a function



Posted by: Denny Cherry
Functions, T/SQL, XML

Recently one of my developers asked me to begin returning data from a function as XML instead of a comma separated list.  My thoughts on this was awesome, another cursor getting removed from the system.  I'll write a quick FOR XML AUTO, ROOT('root') at the bottom of the SELECT statement being...

  Bookmark and Share     3 Comments     RSS Feed     Email a friend

February 16, 2009  9:53 PM

Processing XML files with SQL Server functions



Posted by: Denny Cherry
OPENXML, SearchSQLServer.com, XML

I just published a new article on SearchSQLServer.com called Processing XML files with SQL Server...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

December 15, 2008  9:00 AM

Back To Basics: Getting Data from an XML Document



Posted by: Denny Cherry
Back To Basics, T/SQL, XML

One of the most popular ways to get data multiple pieces of data in a single parameter from one stored procedure to another, or from a client application to the database is to use XML. This can be done in SQL Server 2000 by using the NTEXT (or TEXT) datatype, and in SQL 2005 using the XML...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

January 7, 2008  8:00 AM

XML in the database. What’s the big deal any way?



Posted by: Denny Cherry
Data Types, T/SQL, XML

So, we've had the ability to use XML within the SQL Server databases since SQL 2000 came out.  What's the big deal you ask?  How can I use it to make my life easier you also ask? When I first started looking into this whole XML thing I was thinking the same thing.  How is this blob of data...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

January 3, 2008  8:00 AM

Using a foreach loop to process an XML document.



Posted by: Denny Cherry
DataManagement, SQL, SQL Server 2005, SQL Server 2008, SSIS, XML

Receintly I was working on a project where I needed to use a foreach loop with an SSIS project, but couldn't for the life of me get it to properly process the XML document which I...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1