| Author |
Message |
MarkThornton
Joined: 14 Feb 2008
Posts: 9
Location: School of Clinical Medicine, University of Cambridge
|
 Posted: Wed Apr 16, 2008 4:00 pm Post subject: Feature Request for SQL Doc - Stored Procedures |
 |
|
I want to provide summaries of several Stored Procedures to a Web Developer, who will be calling them from a website that he is building. I could do this task better if SQL Doc had the following extra features:
a) For each parameter, record if it has a default. (SQL Server Management Studio gives this information.)
b) Allow me to suppress the SQL Script. It is of no interest to my audience.
Are either of these features planned for implementation? If so, please could you give me an approximate implementation date?
Thanks in advance.
Mark Thornton |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Thu May 08, 2008 2:41 pm Post subject: |
|
|
Hi Mark,
It is possible to omit the SQL script from the documentation by modifying the SQL Doc stylesheet. First, open %programfiles%\red gate\sql doc 1\style1\style\master.css with Notepad. Locate the list starting with .sqlscript and add the following: visibility: hidden;. For instance:
| Code: |
/* SQL Script */
.sqlScript #sqlScript
{
padding: 5px;
background-color: #CCCCCC;
border: 1px solid #888888;
font-family:Courier New ;
font-size:90%;
visibility: hidden;
} |
Please note that the script can still be seen if your user accesses the source of an HTML documentation file, but the script will be invisible on the web page.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
MarkThornton
Joined: 14 Feb 2008
Posts: 9
Location: School of Clinical Medicine, University of Cambridge
|
| Posted: Thu May 15, 2008 9:01 am Post subject: |
|
|
Brian,
Thanks for this advice, it is helpful.
I hope you enjoyed your recent shopping trip! 
Best wishes,
Mark |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Thu May 15, 2008 10:10 am Post subject: |
|
|
Hi Mark,
It was very good, thanks! I still don't know what to do with the leftover £22...
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
