Running a SQL file from Query Analyzer 1

[Lekar]

Hi. I remember some years ago that ORACLE has a statement that runs a sql file. I want to do the same from Query Analyzer. I want to build another sql file like this:

ExecuteSQLFile 'C:\SQLScript1.sql'
ExecuteSQLFile 'C:\SQLScript2.sql'
ExecuteSQLFile 'C:\SQLScript3.sql'
ExecuteSQLFile 'C:\SQLScript4.sql'

Obviously 'ExecuteSQLFile' is a statement similar to the one I'm looking for. I m doing that, because I don't want to put all the sentences from the 4 files in only 1 file.

Any help would be appreciate.

Lenin.

 

[nigelrivett]

see osql in bol.
it's a command line utility so

exec master..xp_cmdshell 'osql...'

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Lekar]

Thanks Nigelrivett. It works very well.

Lenin.