SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 06:14 AM
| ||||
| ||||
 How to build Gui or forms to wrap SQL queries that are normally run in query analyzer Hi all, I'm a newbie to SQL and I need help with investigating what ways are possible to build an interface of some sort that wraps around a SQL query script. I have a simple SQL query which we normally run inside Query Analyzer to update certain fields in the SQL DB based on FQDN provide by the user. The user normally opens up the query, edit the script to replay the xxxxx in the line "set @FQDN="xxxxx" with the node name and then fires it off. I would like to know what are the ways to wrap a simple user interface around it so the user does not have to open and edit the script directly. A simple GUI or Excel type form interface that has a free form text field for input and then a button to run the script. Obviously, I would like to see the output in some sort of output pane as well. Is this something that can be done in Query Analyzer ? Thanks in advance, Michael.      |
|
02-29-2008, 06:14 AM
| ||||
| ||||
| Re: How to build Gui or forms to wrap SQL queries that are normally run in query analyzer "MichaelC" <michael_w_chan@hotmail.com> wrote in message news:35d77809.0502171621.2400034e@posting.google.c om... > Hi all, > > I'm a newbie to SQL and I need help with investigating what ways are > possible to build an interface of some sort that wraps around a SQL > query script. > > I have a simple SQL query which we normally run inside Query Analyzer > to update certain fields in the SQL DB based on FQDN provide by the > user. The user normally opens up the query, edit the script to replay > the xxxxx in the line "set @FQDN="xxxxx" with the node name and then > fires it off. > > I would like to know what are the ways to wrap a simple user interface > around it so the user does not have to open and edit the script > directly. A simple GUI or Excel type form interface that has a free > form text field for input and then a button to run the script. > Obviously, I would like to see the output in some sort of output pane > as well. > > > Is this something that can be done in Query Analyzer ? > > Thanks in advance, > Michael. The closest thing in QA is the "Replace Template Parameters" option which pops up a window to input values which then replace placeholders in a template. But that's a very basic, limited tool, and QA isn't really intended for end users - it's a development/DBA tool. If you need to build a GUI, then the best solution is probably going to be the tool or language you have most experience with, eg. Access, C#, VB, ASP etc. I believe that Access is a common tool for building front ends for MSSQL applications, but I've never used it for that myself. Simon |
Linear Mode
