|
Home > Archive > Microsoft SQL Server forum > November 2005 > LOAD .SQL file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| mr.nitinjain@gmail.com 2005-11-29, 3:23 am |
| 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!!!
| |
| Brian Cryer 2005-11-29, 7:23 am |
| <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
>
>
|
|
|
|
|