Using a parameter prompt in a SQL Scriptgreenspun.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
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,
-- Anonymous, September 17, 1999