INSERT XML into SQL Server 2008 database
Yes, there are issues when you try to insert XML into SQL Server 2008 and the XML contains an encoding instruction line. I typically get around using the CONVERT function which allows me to instruct SQL Server to skip those instructions – use something like this: INSERT INTO testfiles (filename, filemeta) VALUES (‘test.mp3’, CONVERT(XML, N'<?xml … Read more