[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Query Analyzer - Prompting for a value

Hi Folks,

I need to write a script which will prompt the person running the script for their name.  Is this possible to do at all?

Thanks for any help,

Stuart.
0
Stuart_Johnson
Asked:
Stuart_Johnson
1 Solution
 
nmcdermaidCommented:
Not in query analyzer.

Thwe simplest way I can think of to do this is:


-A DTS package, but the user will require DTS runtimes on their PC

or

-A batch file (which can prompt for a name then use OSQL to run your script). Again they need OSQL installed

OR

-VBScript which is has slightly more sophisiticated input and usually all the libraries required are installe by default on any windows PC


0
 
imran_fastCommented:
No query analyzer will not prompt for any user input. try using any other frontend application for that.
0
 
Stuart_JohnsonAuthor Commented:
Thanks for the info guys.  I figured as much.  I just needed confirmation to prove it.

Stu.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now