Using a parameter prompt in a SQL Script

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi, I would like to create a maintenance script for version 6.5 in which I have a cursor which processes multiple rows. In my fetch loop I would like to prompt the user for an input value which I can put into a local variable. Then I would like to use the local variable to do some processing. Do you know how to do this or have any examples? Thanks, Paul Tribe

-- Anonymous, September 16, 1999

Answers

Paul,

You don't do it with Transact SQL alone. Transact SQL is supposed to be "server side" only, your client code (batch files, Visual Basic, Visual C/C++, Delphi, PowerBuilder, etc.) will have to handle the "client side" issues of prompting the user.

Wish I could have been more helpful,

Eric

-- Anonymous, September 17, 1999


Moderation questions? read the FAQ