While you performing fetch operation using remote objects with linked server when it having XML column, it raise above above such error "Xml data type...

Configuration is one of the major thing that you need to keep in mind while building any application. Either its an Windows Forms application or a Web site, configuration file is always needed. We write all the configuration that are needed to be changed after it is being deployed in confugration fi...

XML specialist Alex Brown, who was involved in the ISO standardisation of Microsoft’s Open XML – still perhaps best known as OOXML – says Microsoft has failed to honour the commitments it made when the standard was approved.

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 exam...

Introduction This is the fifth and final 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 some tips and tricks used to increase OpenXML and XQuery performance. Refresher The purpose behind this series of posts is to provide .Net Deve...

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 ...

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 T...

Update Multiple Record in database table using xml ...

I've been writing a blog post and needed a way to generate HTML table from the SQL table...

The XML document given has blogger IDs given in one element and blog addresses given in another element. Your job is to join the two elements and identify the blog address of each blogger.