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.