How do I call a batch file from within another batch file?

i want to know how to execute a file(which has a sql command) from query analyzer
main problem is
1 a batch file which has following command
(osql -S server -U sa -P sa < C:\SCRIPT.SQL > C:\Result.txt)

2 script.sql has the name of files
CreateTable.sql
CreateProcedure.sql

3 above given 2 files have script to create the tables & procedure respectivly


so please tell me how i can do it

thanking tou


gourav verma November 13, 2003

While calling a batch file from a file by using the call statement in the following way
call bat1.bat
call bat2.bat

But it gives an error like "bat2.bat" is not an interanl or external command or program or batch file.
There is no path problem

Anonymous User May 05, 2005 (Article Rating: )

Unless you batch file exists in one of your PATH variables, you need to provide to full path to the file.

Anonymous User July 13, 2005 (Article Rating: )