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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL

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.

HTH

Dennis
Go to Top of Page
   

- Advertisement -