SQL Server Rocks!
Archives: January 2012
Introduction to XML DML (Part 2) - Using the modify() method: replace value of
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… Read more
0 comments, 9,907 reads
Posted in SQL Server Rocks! on 26 January 2012
Introduction to XML DML (Part 1) - Using the modify() method: insert
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… Read more
0 comments, 12,667 reads
Posted in SQL Server Rocks! on 16 January 2012
Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
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… Read more
0 comments, 68,832 reads
Posted in SQL Server Rocks! on 9 January 2012