-
I got a question in my personal forum this morning requesting help to read values from an XML column. My first reaction was “Well, there is an XQuery lab demonstrating this!”. However, after reviewing the existing XQuery labs, I realized there are no posts demonstrating this. Here is a simple example...
-
Introduction This is the third post in a series of five on Using TVP’s and XML to Transport Relational Data . In this post we’ll take a look at how to use XQuery within Transact-SQL to shred XML data. We’ll also look at how .Net Developers can use XQuery to reduce the number of SQL Server calls required...
-
Introduction This is the second post in a series of five on Using TVP’s and XML to Transport Relational Data . In this post we’ll look at how to use the OpenXML Rowset Provider to shred an XML document into a rowset which can then be used in Transact-SQL statements in which rowset providers such as a...
-
Introduction I’ve been using XML as a means of sending multiple rows of data to SQL Server ever since OpenXML was released in SQL Server 2000. Although 2000 didn’t have an XML data type, the OpenXML Rowset Provider enabled SQL Server to shred a XML string into a rowset which could then be used in Transact...
-
I’ve been working lots of hours lately because our project is just about to go into production. One of my ETL processes has gone through many changes recently because business users are now very actively sending us their late minutes requirements. After making some changes to my ETL process, and re-loading...
-
It is a common scenario when we need to bind or display data from XML File to Silverlight Data Grid. In this article, I have tried to demonstrate this with simple steps. What all we are going to do is Download content of XML file as string using WebClient class. Parse XML file using LINQ to XML. Bind...
-
I learned a new technique recently for shredding delimited strings. It uses the xsd list type and SQL Server's xml data type and is quite powerful. It's a bit different to most shredding techniques in that it allows easy shredding to columns (instead of rows). USE tempdb GO CREATE XML SCHEMA...
-
In the past I have published a few queries that allows you to query SQL Server Reporting Services database – to retrieve specific information about various reports deployed in the Reporting Server Instance. Recently, I got a question in my ASK forum who wanted to identify all the reports that use a specific...
-
One of the applications we worked on recently had to deal with storing TSQL queries in a table and executing them based on some business logic. It was not a very complicated project, but the development team had a tough time with the formatting of the queries stored in the table. This was a huge problem...
-
I saw this question on the forum today and after writing an example that demonstrates this, I thought of including it as part of the XQuery Labs . Here is the sample XML we need to process. <userdata pageid="page9" annotationSetId="80"> <notes /> <notes> <note...
Posted to
Jacob's Blog
by
Jacob Sebastian
on
12-14-2010
Filed under:
Filed under: XQuery-Functions, XQuery-Labs, XML, XQuery, TSQL, BRH, XQuery Tutorials, XQuery Lab, XQuery Functions, #XML, #XQUERY, SQL Server - XQuery, #TSQL, #SQL Server, XQuery Training
-
As a followup questions from the post SQL Server Profiler: System is low on disk space on drive 'C'? here I had a feedback of how to save the server-side trace to a table? Well there is no direct path to do so, rather a roundabout method of once you have collected the trace using server-side...
-
In this article I will show how to add multiple pushpins on the Bing Map in Silverlight in c-sharp. In previous article we saw one of the ways to add multiple locations on the Bing Map in Silverlight by fetching data from SQL Server Database . But in that everything was done in xaml file. As a developer...
Posted to
Dinesh's Blog
by
Dinesh Sodani
on
07-27-2010
Filed under:
Filed under: bing maps, silverlight, bing, brh, xml, RenderTransform, ScaleTransform, Pushpin.RenderTransform, Resizing Pushpin, Geospatial, #SILVERLIGHT, wcf, wcf services, Windows Communication Foundation, bing map, bing map binding with sql server, sql server, #XML, #WCF, web services and wcf serices, multiple pushpin in code behind, c sharp, multiple pushpin
-
In my previous post I described how to add multiple pushpins on Bing Map by fetching data from XML data source .In this article I will step through the process to add multiple locations on the Bing Map by fetching the data from SQL Server Database . We cannot access SQL Server directly from Silverlight...
Posted to
Dinesh's Blog
by
Dinesh Sodani
on
07-13-2010
Filed under:
Filed under: bing maps, map, silverlight, bing, brh, xml, MapItemsControl, RenderTransform, Pushpin, Pushpin.RenderTransform, Resizing Pushpin, #DOTNET, #SILVERLIGHT, wcf data contracts, wcf, wcf services, wcf contracts, wcf service contracts, Windows Communication Foundation, bing map, bing map binding with sql server, sql server, #MAPS, #XML
-
This post aims to be a quick reference source for the beginners and shows a few simple SELECT examples. Reading attributes from an XML variable DECLARE @x XML SET @x = '<author fname="Michael" lname="Howard" />' SELECT @x.value('(/author/@fname)[1]', 'VARCHAR...
Posted to
Jacob's Blog
by
Jacob Sebastian
on
07-01-2010
Filed under:
Filed under: XQuery-Functions, XQuery-Labs, XML, XQuery, SQLSERVER, BRH, XQuery Tutorials, XQuery Lab, XQuery Functions, xquery-lab, #XML, #XQUERY, #TSQL, SQL Server XQuery, XQuery in TSQL, XQuery Training
-
We have seen several examples of writing recursive queries in the earlier blog posts. For a quick recap, you can find some of those posts in the list given below. TSQL Lab 10 - Performing recursive updates in SQL Server TSQL Lab 11 - Writing a recursive procedure to update the count of child items under...
Posted to
Jacob's Blog
by
Jacob Sebastian
on
06-29-2010
Filed under:
Filed under: XML, XQuery, BRH, XQuery Functions, xquery labs, #XML, #XQUERY, SQL Server - XQuery, SQL Server XQuery, XQuery in TSQL, XQuery Training, XQuery Tutorial