JohnDTampaBay
Programmer
We are using XML embedded in our stored procedures to document the functionality, etc. of the stored procedure. The XML is in a comment block so as not to interfere with the procedure. Here's a sample:
I have never worked with XML before. Now Bossman wants me to extract the XML data from the stored procedure code and report to him what procedures contain what XML data.
Has anyone tried to do this? Any advise would be greatly appreciated. --Angel![[rainbow]](/data/assets/smilies/rainbow.gif "[rainbow] [rainbow]")
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.
Code:
/*
<ROOT>
<Author>Me</Author>
<Created>December 2002</Created>
<Revisions>
<Author Name="Me" Date="12-6-2002">Added CreateDate to log.</Author>
</Revisions>
<Summary>This procedure logs object names and types into the WSRObjects table.
</Summary>
<Remarks></Remarks>
<UsedBy></UsedBy>
<Returns></Returns>
</ROOT>
*/I have never worked with XML before. Now Bossman wants me to extract the XML data from the stored procedure code and report to him what procedures contain what XML data.
Has anyone tried to do this? Any advise would be greatly appreciated. --Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.