stored procedures / batch file

  • Hi,

    I have a single test.sql file with about 7 stored procedures in it.

    create proc xxx1 as

    ....

    .....

    go

    create proc xxx2 as

    ....

    .....

    go

    ....

    ....

    create proc xxx7 as

    ....

    .....

    go

     

    to execute this and registered them through a batch file:

    i have it as :

    osql -E -e -dTest -iC:\test.sql

    osql -E -e -dTest -oC:\test_out.txt -n -Q "EXEC xxx1"

    osql -E -e -dtest >>C:\test_out.txt -n -Q "EXEC  xxx2"

    ....

    osql -E -e -dtest >>C:\test_out.txt -n -Q "EXEC xxx7"

    is this a right way to do???

    Thnx.

     

  • This was removed by the editor as SPAM

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply