Notes on SQL

Introduction
When setting the value of an XML column, so-called ‘insignificant’ white space can be removed. Generally this is not an issue but if the white space is required there are a couple of ways to prevent this.
Continue reading →

Tags: CONVERT, T-SQL, White Space, XML, xml:space