How to Batch Execute SQL files in batches using osql/ocmd in sqlserver

Batch Processing of SQL files in batches using osql/ocmd

Note: osql does not support all functions of SQL Server 2008. If you need to use all functions of SQL Server 2008, you can use the ocmd command.

With the osql/ocmd command, to execute SQL files in batches, you must write a batch processing command. For example, if you execute the preceding SQL file, you can write the following statement in the txt file:
Copy codeThe Code is as follows:
Osql-S "127.0.0.1"-U "sa"-P "sa"-d "Northwind"-I "% CD %/1. SQL"
Osql-S "127.0.0.1"-U "sa"-P "sa"-d "Northwind"-I "% CD %/2. SQL"

Save SQL. bat to the same file as above. 1. SQL and 2. SQL. Double-click SQL. bat during execution.