How to run multiple sqlfiles at once in SSMS?

Question

I have multiple SQL files under a directory which are having sequence numbering in the filename.

Folder : TableOperation

00_CreateTable.sql
01_InsertTable.sql
02_UpdateTable.sql
03_DropTable.sql

How do we run these SQL files(00_..,01_..,02_..,03_..) at once in SSMS?

@Larnu How do we run these sql files(00_..,01_..,02_..,03_..) at once in SSMS? — user15350142, Dec 23 '21 at 16:18
Does this answer your question? [Run all SQL files in a directory](https://stackoverflow.com/questions/2583517/run-all-sql-files-in-a-directory) — SMor, Dec 23 '21 at 16:36

score 0 · Accepted Answer · answered Dec 23 '21 at 16:35

0

Switch the query editor to SQLCMD mode

and run

:r 00_CreateTable.sql
:r 01_InsertTable.sql
:r 02_UpdateTable.sql
:r 03_DropTable.sql

answered Dec 23 '21 at 16:35

1

:setvar path C:\"some path" :r $(path)\myfile.sql – user15350142 Dec 23 '21 at 20:25

1 Answers1