Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SqlDevel
Starting Member
18 Posts |
 Posted - 2005-09-04 : 12:40:05
|
| hai everyonei have a requirement.i am writing a very large sp.i have written many comments in that sp.i wanted to generate a document from that comments i have wriiten in that sp.i know a similar thing can be done in vb.net comments.is it possible top do such a thing in .sql file.ie all comments that i have wriiten in my .sql file should be extracted.to a document. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
SqlDevel
Starting Member
18 Posts |
Posted - 2005-09-10 : 16:06:17
|
| i didnt understand what it is doing.i want to get all the comments in an sp .is that sp does thatis it really what i am looking for? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-10 : 16:32:45
|
probably is...this gets the text of the sproc.you just have to parse the comments out.Go with the flow & have fun! Else fight the flow  |
|
|
|
SqlDevel
Starting Member
18 Posts |
Posted - 2005-09-11 : 03:46:57
|
| thank you yes i am working on that spthanks man |
|
|
|
SqlDevel
Starting Member
18 Posts |
Posted - 2005-09-11 : 07:31:02
|
| problem solved worked well using the commentsout put it as xml then used a style sheet.thanks spirit1 |
|
|
|
|
|
|
generating document from comments in sql