LOAD .SQL file

Hi dear members,
Can onyone please tell me that how can we load multiple files/ or even
a single .SQL file stored on any physical location(Hard Disk) from SQL
prompt.
i have written some scripts in diffrent files, now i want to run those
scripts, Do i always need to manually open those scripts and run it on
query analyser or is there some way out.
Please HELP!!!

<mr.nitinjain@gmail.com> wrote in message
news:1133252435.378052.52860@g14g2000cwa.googlegroups.com...
> Hi dear members,
> Can onyone please tell me that how can we load multiple files/ or even
> a single .SQL file stored on any physical location(Hard Disk) from SQL
> prompt.
> i have written some scripts in diffrent files, now i want to run those
> scripts, Do i always need to manually open those scripts and run it on
> query analyser or is there some way out.
> Please HELP!!!

I'm sure there is an easier way (and I genuinely look forward to someone
telling me), but I use .cmd scripts which call osql passing the sql script I
want. That way if I want to run half a dozen scripts I need half a dozen
calls to osql in my .cmd file each of which gets passed one of my sql
scripts.

Hope this helps.
--
Brian Cryer
www.cryer.co.uk/brian

I dont know if this is an option for you, but can you make a DTS package
with sql statements task?
Then you can execute DTS package from command prompt using dtsrun utility.

MC


"Brian Cryer" <brianc@127.0.0.1.activesol.co.uk> wrote in message
 news:caWdnYudXqARsRH
eRVnyuA@pipex.net...
> <mr.nitinjain@gmail.com> wrote in message
> news:1133252435.378052.52860@g14g2000cwa.googlegroups.com... 
>
> I'm sure there is an easier way (and I genuinely look forward to someone
> telling me), but I use .cmd scripts which call osql passing the sql script
> I want. That way if I want to run half a dozen scripts I need half a dozen
> calls to osql in my .cmd file each of which gets passed one of my sql
> scripts.
>
> Hope this helps.
> --
> Brian Cryer
> www.cryer.co.uk/brian
>
>