Run all SQL files in a directory

by

Create a .BAT file with the following command:

for %%G in (*.sql) do sqlcmd /S servername /d databaseName -E -i"%%G"
pause

If you need to provide username and passsword 

for %%G in (*.sql) do sqlcmd /S servername /d databaseName -U username -P 
password -i"%%G"

Note that the “-E” is not needed when user/password is provided

Place this .BAT file in the directory from which you want the .SQL files to be executed, double click the .BAT file and you are done!

More Related Contents:

  1. What is wrong with this DB Diagram? [closed]
  2. I’m getting ‘Column name is invalid in the select list’ error when i execute the query
  3. SQL Server Subquery a
  4. Efficiently convert rows to columns in sql server
  5. Not equal != operator on NULL
  6. SET NOCOUNT ON usage
  7. How can I get column names from a table in SQL Server?
  8. How can I select the first day of a month in SQL?
  9. T-SQL – Insert Data into Parent and Child Tables
  10. Copy tables from one database to another in SQL Server
  11. error, string or binary data would be truncated when trying to insert
  12. Is it possible to specify condition in Count()?
  13. Constraint for only one record marked as default
  14. How to Replace Multiple Characters in SQL?
  15. EXISTS vs JOIN and use of EXISTS clause
  16. SQL count(*) performance
  17. Why is a UDF so much slower than a subquery?
  18. Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
  19. SQL comma-separated row with Group By clause
  20. How to split string using delimiter char using T-SQL?
  21. Get everything after and before certain character in SQL Server
  22. T-SQL trim &nbsp (and other non-alphanumeric characters)
  23. UNIX_TIMESTAMP in SQL Server
  24. I want to use CASE statement to update some records in sql server 2005
  25. Sql Server trigger insert values from new row into another table
  26. How to return a incremental group number per group in SQL
  27. Retrieve column names and types of a stored procedure? [duplicate]
  28. Zero SQL deadlock by design – any coding patterns?
  29. UNION ALL vs OR condition in sql server query
  30. Export table data from one SQL Server to another

Leave a Comment