There are 2 main methods to work with XML Data in SQL.
OpenXML
- Requires error handling to ensure paired usage of sp_xml_preparedocument and sp_xml_removedocument
- Limits maximum memory usage for XML parsing of an instance to 1/8th of allocated SQL memory
- Performs better in many cases than “Nodes” method on low end CPUs
- Pattern to be used:
SET NOCOUNT ON
DECLARE @ErrorMessage NVARCHAR(4000)
DECLARE @ErrorSeverity INT
I received an interesting, and rather funny if I may say, message through LinkedIn today from a recruiter. It had a lot of claims of "Cutting Edge" and "Bleeding Edge" along with a buzzword laden description of the opportunity.
After a long day of several recruiters emailing and then calling me immediately after (while I was reading the email on my phone no less) my irritation drove me to help this recruiter improve his skill-set.
Below was my response.