Hi,

Is there a way to send inputs to T-SQL scripts interactively from the command line ? For example, I have a script that takes a backup of the database. I wish to supply the inputs to it like the backup media, the database name etc from the command prompt interactively. How is this possible. Please help.

Thanks in Advance,
Vidya.

OSQL is a command line utility, which u can use to manupolate the sql server.

Hope this will help u,

c:\ osql -S <Server Name> -U <User Name> -P <Password> -d <database Name>
-Q "execute sp_addumpdevice........... <T-SQL>"


Amit Jain
Sr. Software Engineer

vmaruv, instead of making two instences for a question, try resolve ur query in sinle instences.

let us explain so that we can provide the solution according to ur requirement.



Amit Jain
Sr. Software Engineer

Here is my requirement in detail :

I have a T-SQL script that takes a database backup. This script can be run using osql as you suggested. But, the user is not willing to open the script and make changes to the the parameters like @databasename @device each time.

He wishes to interactively enter this from command prompt while running the script. Like : c:\ osql -U -P ...... test.sql It should prompt :

Enter database name : Northwind
Enter Device name : DISK

(these values should be assigned to @databsename and @Device in the scipt).

I would like to know how this is achievable.


Thanks in Advance.
Vidya

U have to create the batch file (.bat)

This batch file takes two parameter , by default its takes %1 and %2 as varibles.
Change the sql query according to your requirement.

here u have to take first parameter as database name and another as device name.

----------------------------------------------
@echo off

:: check first parameter is not null

IF %1=="" goto error1

:: check 2 parameter is not null

IF %2=="" goto error1


osql -S hondasrv -U std -P std -d pubs -Q "select * from %1"

exit

:error1
  echo "Please enter table name"


Amit Jain
Sr. Software Engineer