Archives

Archives / 2012 / January
  • Introduction to XML DML (Part 2) - Using the modify() method: replace value of

    Tags: Xml, XML DML, modify(), replace value of, XPath

    This is the second part of a 3 part blog which will attempt to show some different ways of how you can use the xml modify() method to update the contents of an XML document. This part, starting at the absolute basics, will cover the ability to update data in an existing XML document

    XML DML is an extension of the XQuery language that allows us to do in place updates of the contents of an XML document. XML DML is very flexible and most scenarios can be dealt with quite nicely with the use of the … more

  • Introduction to XML DML (Part 1) - Using the modify() method: insert

    Tags: Xml, XML DML, modify(), insert, XPath

    This is the first part of a 3 part blog which will attempt to show some different ways of how you can use the xml modify() method to update the contents of an XML document. This first part, starting at the absolute basics, will cover the ability to insert data into an existing XML document

    XML DML is an extension of the XQuery language that allows us to do in place updates of the contents of an XML document. XML DML is very flexible and most scenarios can be dealt with quite nicely with the use … more

  • Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS

    Tags: Collations, Unicode, Performance, varchar, nvarchar

    This is a revised post of an original article that I first published in December. Even though I thought that I was very meticulous in my research, something was pointed out to me that I was totally unaware of - Unicode character expansions. So apologies to the community with regard the first article that I published as some of the original content could have been misleading. Here is a new revised article that explains character expansions and how it can affect the comparison of data with these … more