Home
About
Performance
Certifications
SVEK News Page
tips and tricks
Tip of the day
Summary of Skills
SQL Server Tips
Some interesting sites
Interesting sites
Guest Book
Contact Information
Software Development
Services
CompanyHistory

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 ]

Send mail to Webmaster with questions or comments about this web site.
Copyright©1999 SVEK Computing Ltd
Last modified: January 27, 2003