I need a SQL Server equivalent

I need to create one script that will execute several other scripts.

Using Oracle I can create a file called foo.sql, which is made up of other scripts names. For example, if I were to open foo.sql it contains:

@c:\temp\a
@e:\mystuff\b

And then by either invoking sqlplus via the command line or the GUI I can run

@foo

and it executes both a.sql and b.sql


What is the equivelent in SQL Server Management Console that I could run that would do the same thing?

Thanks in advance

Scout14

I believe that what you're looking for is OSQL. Either that or you can create a "graphical" script using SSIS. Read about both in Books Online which is the help system that comes with SQL Server.

__________________
--Jeff Moden

And, no... it's not a 100% equivalent. There's not much that's 100% equivalent between Oracle and SQL Server.

__________________
--Jeff Moden

While I'm not looking for an "exact" match I am looking for something similar.

And I guess what I am really looking for is for someone to show me an example.

Can I create a script called foo and have it contain other script names that through OSQL or SQL Server Management Console, New Query window, execute foo?