Posted by Brian Cryer on 11/29/05 12:25

<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

[Back to original message]