Encapsulate Scored Procedure Enhancement

bcpreece

In my office we have a standard documentation header. It would be nice if you could set up a custom header for the stored procedure. It looks something like this.

/**********************************************************************
* Routine Name: Procedure Name
*
* Purpose: What is the purpose of it
*
* Inputs: @intCollStatus int = 0, -- default = 0
	 @strOrderBy varchar(50) = 'ACCT_NO', -- default = ''
	 @intOrderByException int = 0, -- default = 0, 1 = Phones, 2 = SSN
	 @intWildCard int = 0,  -- 0 = no wildcard, 1 = wildcard
	 @strCriteria varchar(50) = ''	,
	 @intColHeaders int = 0
*		
*
* Returns:  	None
*
* Revision History:
* Version	Date		Person			Description
* =======	=====		============		================
* 1.0.0		05/05/2006	Developer Name		Created this routine.
*1.0.0      04/19/2006   Developer Name		 cast account Number to varchar	
**********************************************************************/

Eddie D

Thank you for your post into the forum.

I will submit this feature request which will hopefully appear in a later version of SQL Refactor.

Many thanks regarding your feedback on SQL Refactor.

Eddie Davis
Red Gate Software Ltd
Technical Support Engineer