In a Asp.Net 3.5 application I need to read this XML chunk, inside a Stored
Procedure (sql Server 2008):
declare @xml varchar
set @Xml =

in SQL Server 2008,
I am trying to create a XML SCHEMA COLLECTION for the following xml, but I
am getting the error
Msg 2378, Level 16, State 1, Line 23

I am creating an xml blob out of concatenated string data successfully in sql
server 2008. I have been asked to now append results from another column that
is already XML data type to this same column. I figured I could just
concatenate the two data sources together and the two ...