Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2003-06-02 : 07:41:34
|
| Frank writes "Hello.I have recently started a job where I have to manually run SQL queries on several diffent tables in one database. These queries insert data and also find and delete duplicates. I'd like to know if I can use OSQL to run these queries, but in the following manner.osql "myquery.sql"I am also a programmer with PERL, so if this is possible I'd like to know so I can start automating this crap. It sucks to do it manually.Thank you.Frank" |
|
|
dsdeming
479 Posts |
Posted - 2003-06-02 : 07:54:04
|
| OSQL can be executed from the command line, and you can pass it the names of query files to be executed. See osql Utility in BOL.HTHDennis |
 |
|
|
|
|
|