November 24, 2009 at 9:58 am
Hi,
I have some 10 SQL Files (*.sql) in a folder. I want to run all this 10 Files in a single shot. Is it possible through sql script? If yes, Please tell me how to do.
Thanks!!!
November 24, 2009 at 10:01 am
Pardon my ignorance, can I know why you need to run multiple .sql files from script?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 24, 2009 at 10:08 am
Bru Medishetty (11/24/2009)
Pardon my ignorance, can I know why you need to run multiple .sql files from script?
Thanks for your reply.
There are 10 different part of script for 10 issues. For that, we are thinking instead of running one by one, possible to run all the script at a shot.
November 24, 2009 at 10:18 am
Thanks for clarifying, but if there are multiple conditions and you run those files to solve that issues, running all of them at the same time will it not cause any locking (if all of them are accessing the same objects?)
Have you considered that?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 24, 2009 at 10:25 am
Make 10 stored procedures, then control & schedule through SQL.
November 24, 2009 at 10:39 am
homebrew01 (11/24/2009)
Make 10 stored procedures, then control & schedule through SQL.
ohh ... yes, that makes good... 🙂
November 24, 2009 at 10:42 am
sqluser-1118722 (11/24/2009)
homebrew01 (11/24/2009)
Make 10 stored procedures, then control & schedule through SQL.ohh ... yes, that makes good... 🙂
So you never knew Stored Procs existed 😉
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply