Monthly Archives: July 2008

Insert an XML document into an existing XML document

/* Though SQL Server 2005 supports xquery, it does not support insert an XML document into another XML document. The xml data type is supported when creating xml document by FOR XML AUTO, FOR XML RAW, FOR PATH. E.g., In AdventureWorks … Continue reading

Posted in XML, XQuery and XPath | Leave a comment

A severe error occurred on the current command

Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.   A scary message, isn’t it? Create the following stored procedure and run it in SSMS:   … Continue reading

Posted in SQL server 2005 | Leave a comment