Group of Files run in a single shot?

  • 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!!!

  • Pardon my ignorance, can I know why you need to run multiple .sql files from script?


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • 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.

  • 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?


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Make 10 stored procedures, then control & schedule through SQL.

  • homebrew01 (11/24/2009)


    Make 10 stored procedures, then control & schedule through SQL.

    ohh ... yes, that makes good... 🙂

  • 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 😉


    Bru Medishetty

    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