Looking for Tool for Stored Proc execution
-
Hi there, First, let me clarify, this is NOT programming question :-) Have been around for a while to see people criticized and I have also criticized others for doing that.. ;) I am looking for some tool (preferably browser based) which I can give to non-developer to run some of the stored procedures (SQL server). For example, they can select a SP from drop-down, then few text boxes appears where they can enter data (for parameters) and execute the SP. Result may be displayed in some grid or downloaded in csv. I can build it, but just thought of checking if there is some open source tool available before investing time/energy. Any help appreciated.
Thanks, Milind
-
Hi there, First, let me clarify, this is NOT programming question :-) Have been around for a while to see people criticized and I have also criticized others for doing that.. ;) I am looking for some tool (preferably browser based) which I can give to non-developer to run some of the stored procedures (SQL server). For example, they can select a SP from drop-down, then few text boxes appears where they can enter data (for parameters) and execute the SP. Result may be displayed in some grid or downloaded in csv. I can build it, but just thought of checking if there is some open source tool available before investing time/energy. Any help appreciated.
Thanks, Milind
-
MT_ wrote:
this is NOT programming question
But it's close; and definitely not Lounge material.
-
MT_ wrote:
this is NOT programming question
But it's close; and definitely not Lounge material.
Really? Asking whether a piece of software exists that does x is close to a programming question? I would have thought it, by definition, a non-programming question in that its principal aim is to avoid programming altogether!
I am not a number. I am a ... no, wait!
-
MT_ wrote:
this is NOT programming question
But it's close; and definitely not Lounge material.
It is Lounge material and most definitely not a programming question.
"I had the right to remain silent, but I didn't have the ability!"
Ron White, Comedian
-
Hi there, First, let me clarify, this is NOT programming question :-) Have been around for a while to see people criticized and I have also criticized others for doing that.. ;) I am looking for some tool (preferably browser based) which I can give to non-developer to run some of the stored procedures (SQL server). For example, they can select a SP from drop-down, then few text boxes appears where they can enter data (for parameters) and execute the SP. Result may be displayed in some grid or downloaded in csv. I can build it, but just thought of checking if there is some open source tool available before investing time/energy. Any help appreciated.
Thanks, Milind
Not that I know of, and I'd prefer to develop something custom anyway. Perhaps your application needs a utility or administrative page that allows a properly authorized user to perform such tasks? One app I worked on a while back had some such functions that allowed an admin to do certain things (e.g. refresh the cache) via URL/query string.
-
It is Lounge material and most definitely not a programming question.
"I had the right to remain silent, but I didn't have the ability!"
Ron White, Comedian
-
Hi there, First, let me clarify, this is NOT programming question :-) Have been around for a while to see people criticized and I have also criticized others for doing that.. ;) I am looking for some tool (preferably browser based) which I can give to non-developer to run some of the stored procedures (SQL server). For example, they can select a SP from drop-down, then few text boxes appears where they can enter data (for parameters) and execute the SP. Result may be displayed in some grid or downloaded in csv. I can build it, but just thought of checking if there is some open source tool available before investing time/energy. Any help appreciated.
Thanks, Milind
You can try SQL Reporting Services; I'm not sure you would be able to execute stored procedures, though, but since you are dealing with SQL Server then maybe you could try. It needs an non-express edition. Considerations for Installing Reporting Services[^]
You always obtain more by being rather polite and armed than polite only.
-
That's three of you telling me that the question is OK for the Lounge, But not one who has tried to answer it.
I'm not quite sure what one has to do with the other. I see no correlation. :doh:
"I had the right to remain silent, but I didn't have the ability!"
Ron White, Comedian
-
I disagree. This is Lounge material and not a programming question, it's a "How do I avoid programming" question. @_MT: Not that I have an answer for you, sorry.
- I would love to change the world, but they won’t give me the source code.
-
Hi there, First, let me clarify, this is NOT programming question :-) Have been around for a while to see people criticized and I have also criticized others for doing that.. ;) I am looking for some tool (preferably browser based) which I can give to non-developer to run some of the stored procedures (SQL server). For example, they can select a SP from drop-down, then few text boxes appears where they can enter data (for parameters) and execute the SP. Result may be displayed in some grid or downloaded in csv. I can build it, but just thought of checking if there is some open source tool available before investing time/energy. Any help appreciated.
Thanks, Milind
Hah I wrote one of them in the 90s as an adjunct to a reporting system. It is not as simple as you hope, supplying check and date controls needs to check the data type of the parameter and text boxes are a waste of time. You have to supply combo's to select from. Use can't type for shyte! I ended up building tables for proc/parameters to service that and it certainly wasn't browser based!
Never underestimate the power of human stupidity RAH
-
Hah I wrote one of them in the 90s as an adjunct to a reporting system. It is not as simple as you hope, supplying check and date controls needs to check the data type of the parameter and text boxes are a waste of time. You have to supply combo's to select from. Use can't type for shyte! I ended up building tables for proc/parameters to service that and it certainly wasn't browser based!
Never underestimate the power of human stupidity RAH
I would probably create a class that lets me specify an english name, a storedproc name, and a list of parameter objects with values set to a reasonable default. The interface would present controls based on object type. This would make a really interesting article.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
I would probably create a class that lets me specify an english name, a storedproc name, and a list of parameter objects with values set to a reasonable default. The interface would present controls based on object type. This would make a really interesting article.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013My design had a table name, primary key field and display field for parameters requiring combo data. It worked quite well but was very under utilised as the user was more interested in the reports (Crystal in those days bleh)
Never underestimate the power of human stupidity RAH
