running a sql statement from a .sql or .txt file

[smsinger3]

Hello all. I would like to run a sql statement from a .txt file (or .sql file). I know in Query Analyzer I could File/Open/xxxx.sql then execute the statement, but there are many of them. I would like to save one .sql file with all the "executes" I can run them peridocially. Each of these .sql files can change periodically.

Any ideas how to run .sql file from Query Analyzer?

Your help is very much appreciated!

Steve
sms@hmbnet.com

 

[bitbrain]

How about a .bat/.vbs script to execute each of the .sql files via isql?

 

[foxdev]

We had a thread last week on this. You can use ISQL.EXE with the -I parameter to feed it a .SQL file. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[Cagliostro]

I'm not sure what I understand.
In the same sql you can put many queries without problems. Also you can create a C program to read them and to execute.
John Fill