Red Gate forums :: View topic - Feature Request for SQL Doc - Stored Procedures
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 1
SQL Doc 1 forum

Feature Request for SQL Doc - Stored Procedures

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
MarkThornton



Joined: 14 Feb 2008
Posts: 11
Location: School of Clinical Medicine, University of Cambridge

PostPosted: Wed Apr 16, 2008 4:00 pm    Post subject: Feature Request for SQL Doc - Stored Procedures Reply with quote

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
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6671

PostPosted: Thu May 08, 2008 2:41 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
MarkThornton



Joined: 14 Feb 2008
Posts: 11
Location: School of Clinical Medicine, University of Cambridge

PostPosted: Thu May 15, 2008 9:01 am    Post subject: Reply with quote

Brian,

Thanks for this advice, it is helpful.

I hope you enjoyed your recent shopping trip! Very Happy

Best wishes,

Mark
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6671

PostPosted: Thu May 15, 2008 10:10 am    Post subject: Reply with quote

Hi Mark,

It was very good, thanks! I still don't know what to do with the leftover 22...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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