The easiest and fastest way to create ad hoc reports from SQL Server
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Converting VARBINARY to VARCHAR using FOR XML

We have seen a number of string manipulation examples using XML. Here is yet another example that uses FOR XML to convert a VARBINARY value to VARCHAR. Some one asked me this question in one of the forums. The story is like this. The OP did a data migration...
Posted: 06-13-2009 9:09 AM by Jacob Sebastian | with 2 comment(s)
Filed under: , , ,

XQuery Lab 41 - Another string parsing example using XQuery

We have seen a number of string parsing/manipulating examples using XQuery and FOR XML in the previous sessions of XQuery Labs . This session presents yet another string parsing example using XML data type methods. Here is the string value that we need...
Posted: 02-05-2009 9:01 PM by Jacob Sebastian | with no comments
Filed under: , , ,

XQuery Lab 40 - Extracting words matching a pattern from a varchar column

We saw a number of string manipulation examples using FOR XML and XML Data Type methods. Here is yet another string parsing requirement that we will solve using the XML Data type methods. In this post, we will see how to extract words from strings stored...
Posted: 01-27-2009 8:56 PM by Jacob Sebastian | with no comments
Filed under: , , ,

FOR XML PATH - Matching a delimited string against another delimited string

We have seen a number of posts on various string operations using XQuery functions and FOR XML operator. This post explains how to match a delimited string against another delimited string. I wanted to share a piece of code that I wrote to help a member...
Posted: 09-25-2008 12:47 PM by Jacob Sebastian | with no comments
Filed under: , , ,

FOR XML PATH - How to generate a Delimited String using FOR XML PATH?

One of the two common string operations that we do often are 'parsing' delimited strings and 'generating' delimited strings. This post explains how to generate a delimited string using FOR XML. I like XML and many of you might have noted...
Posted: 08-14-2008 9:10 AM by Jacob Sebastian | with 3 comment(s)
Filed under: , , ,

XQuery Lab 19 - How to parse a delimited string?

  XML Data Type functions can be used to perform a number of string operations. This post explains how to parse a delimited string using the XML approach. The XML approach helps you to avoid the WHILE-LOOP that you might need with most other approaches...
Posted: 08-14-2008 1:03 AM by Jacob Sebastian | with no comments
Filed under: , , ,

Copyright © Beyondrelational.com