469,081 Members | 1,792 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

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.
Jul 23 '05 #1
1 2528

"MichaelC" <mi************@hotmail.com> wrote in message
news:35**************************@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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by jim_geissman | last post: by
6 posts views Thread by A.Weinman | last post: by
4 posts views Thread by Akhenaten | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.