microsoft.public.sqlserver.server

Author

parameter passing

bhughes

2002-06-27, 4:25 pm

Is it possible to pass parameters into a T-SQL script
using the osql command at the DOS prompt? Example:

DOS> osql -U scott -P tiger -d ORCL -S MYDB -n -e -i
DUMMY.SQL %p1% %p2%

Where P1 and P2 are local variables.

If parameter passing is possible, please supply an example
or point me to the documentation. Thanks.

Sponsored Links