Silverkight Viewer for Reporting Services
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.

Jacob's Blog

Recent Blog Posts

Most Viewed

Archive

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery

This post aims to be a quick reference source for the beginners and shows a few simple SELECT examples....
Posted: 07-01-2010 11:53 AM by Jacob Sebastian | with no comments
Filed under: , , , , , , , , , , , , , ,

XQuery Lab 56 – Inserting elements with UNICODE values

This post explains how to write XML DML queries uisng XQuery in TSQL that deals with UNICODE character strings....
Posted: 06-09-2010 6:02 AM by Jacob Sebastian | with no comments
Filed under: , , , , , , ,

XQuery Lab 55 – Extracting values from XML elements that matches a string pattern

Here is another XQuery exercise that uses the contains() function to match a string pattern against an XML element and retrieves values from a sibling element. Here is the input data for this challenge. <ArrayOfCustomField> <CustomField> <Name>abc<...
Posted: 04-07-2010 9:48 AM by Jacob Sebastian | with 3 comment(s)
Filed under: , , ,

XQuery Lab 54 – Modifying an XML document with a SELECT Query

This post explains how to modify an XML document from a SELECT query in TSQL...
Posted: 03-31-2010 6:37 PM by Jacob Sebastian | with 2 comment(s)
Filed under: , , ,

XQuery Lab 53 – Reading information from SQL Server Extended Event Information XML

This installment of XQuery Labs explains how to read information from the XML document generated by SQL Server Extended Events....
Posted: 03-23-2010 6:42 PM by Jacob Sebastian | with no comments
Filed under: , , , , , ,

XQuery Lab 50 – Reading data from Google Analytics Atom Feed

One of my friends emailed me this morning asking help for reading data from Google Analytics Atom feed, using Query with TSQL. My friend sent me a sample XML document he obtained from Google Analytics and here is the query that reads information from...
Posted: 12-23-2009 8:20 AM by Jacob Sebastian | with no comments
Filed under: , , , ,

XQuery Lab 49 – Deleting rows from a table based on the data in an XML document

We have seen a few examples that demonstrated how to delete elements and attributes from XML documents. In this lab, let us see how to delete rows from a table, based on the data in an XML document. DECLARE @t TABLE (id INT ) INSERT INTO @t(id) SELECT...
Posted: 08-26-2009 11:24 AM by Jacob Sebastian | with no comments
Filed under: , , , ,

XQuery Lab 48 - Sorting Query files in SQL Server Management Studio (SSMS) Solution/Project

I was working on my presentation for 24-hour-pass event on 2nd September and came across the sorting issue with the solution explorer. I have a number of script demos and I wanted to organize them by name. No matter, what I did, the solution explorer...
Posted: 08-22-2009 2:36 PM by Jacob Sebastian | with 3 comment(s)
Filed under: , , , , ,

XQuery Lab 47 – Generating HTML table from XML Data

Welcome to XQuery Lab 47. In this lab, we will see how to generate an HTML table from an XML document, using XQuery. Here is the source data: < CUST COMPANY ="Company1" CONTACT ="Jacob" /> < CUST COMPANY ="Company1"...
Posted: 08-19-2009 7:00 AM by Jacob Sebastian | with no comments
Filed under: , , , ,

XQuery Lab 46 – Extracting Zip Code from an Address Value

I just came across a task to extract ZIP code values from the address column of a table. The address is a single string that contains information such as street, city, state, zip code, apartment number etc. The data comes from a legacy system where the...
Posted: 08-12-2009 10:11 AM by Jacob Sebastian | with no comments
Filed under: , , ,

New XQuery functions introduced in SQL Server 2008: upper-case() and lower-case()

The XQuery implementation of SQL Server 2005 supported only a limited number of XQuery functions. SQL Server 2008 added support for two more XQuery functions: upper-case() and lower-case() Both these functions are pretty simple to understand and self...
Posted: 05-27-2009 10:25 PM by Jacob Sebastian | with no comments
Filed under: ,

Copyright © Beyondrelational.com