I had an idea at work a while ago that would allow an authorized user (based on the Intranet) to dynamically execute a stored procedure in a designated schema.
The need arose when I discovered that our network/system administrator was searching for saved queries, changing some variables, connecting to the production server, and then executing them.
I thought it would be nice to put these into their own schema that a page could find these, and prepare a nice and easy way for them to be executed.
Development is still in process, and I’m hoping to have version 1 released in the next few weeks.
If you or your company would like to stay up to date on this, or if you have any questions or input, please ship me an email in the form below.
What will come in these versions:
|Get a list of procedures based on a schema||X||X||X|
|Display meta-data about procedure||X||X||X|
|Display meta-data about parameters||X||X||X|
|Data input – Textbox||X||X||X|
|Data input – Checkboxes||X||X|
|Data input – Radio Buttons||X||X|
|Data input – Drop Down List||X||X|
|Populate input with Data (SQL)||X||X|
|Populate input with Data (String)||X||X|
|Populate cascading input with Data (SQL)||X|
|Data Validation – More Than/Equal||X||X|
|Data Validation – Less Than/Equal||X||X|
|Data Validation – Required||X||X|
|Data Validation – Is Date||X||X|
|Data Validation – Is Numeric||X||X|
|Data Validation – Regular Expression||X||X|
|Visual way to manage Proc||X|
[contact-form-7 id=”204″ title=”SQL Tool”]