Home
Feedback
History
About
Tip of the day
Interesting sites
Contact Information
Services
News

Tip of the day

Setting DOS variables from SQL

Create a stored procedure (if parameters are needed) or a view to extract the details in the format

Select @Cmd='set MODE='+ Mode from table where ...

Use ISQL to extract the details as follows

isql -Usa -P -S -Q"sp_getMode %1" -oSetmode.bat -h-1 -n

Run the batch File and you know have a dos variable with MODE set to your required value

Home ] tips and tricks ]

Send mail to Webmaster with questions or comments about this web site.
Copyright © 1999 Svek Computing Limited
Last modified: January 07, 2000