"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