how to run all files from a script folder using sql query [duplicate]

Question

In the directory 'C:\scripts' I am having script files in '.sql' format.How to execute all these files at the time using sql query from my SQL SERVER MANAGEMENT STUDIO.

hi, welcome to StackOverflow! Please take the tour here: stackoverflow.com/tour — Eduard Uta
– Eduard Uta, Commented Nov 28, 2014 at 10:39

Community · Accepted Answer · 2017-05-23 12:25:42Z

1

If this linked post contains the info you need then I suggest marking your post as duplicate of the linked one: Run all SQL files in a directory

Otherwise, check if this helps: http://www.sql-server-helper.com/tips/execute-sql-scripts-batch.aspx

edited May 23, 2017 at 12:25

CommunityBot

11 silver badge

answered Nov 28, 2014 at 10:49

Eduard Uta

2,6165 gold badges30 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sindhoo Oad · Accepted Answer · 2014-11-28 10:47:12Z

0

make a batch file with anyname.bat and save it in the same directory, save it and run it. this sample of mysql

@ECHO OFF

ECHO Running scripts
FOR %%i IN (*.sql) DO mysql -uroot -proot databasename< %%i

ECHO Finished!
pause

answered Nov 28, 2014 at 10:47

Sindhoo Oad

1,1942 gold badges15 silver badges31 bronze badges

2 Comments

Saravana Kumar Over a year ago

please give query for sql

Sindhoo Oad Over a year ago

sql is Structured Query Language, it is used to query your database not to run .sql files placed somewhere in your system. what is the need to do so?

Collectives™ on Stack Overflow

how to run all files from a script folder using sql query [duplicate]

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related