Command Line, File Name for each script executed. SQL

Question

I have the following files in my folder:

Script1.sql
Script2.sql
Script3.sql

The below command executes each script successfully:

@echo off

set /p sname= Please enter the servername:
set /p dbname= Please enter the databasename:

ECHO started the batch process at %TIME%  >output.txt

for %%f in (*.sql) do (
sqlcmd.exe  -S %sname% -d %dbname% -i %%f  >>output.txt

%~f0"

    )
pause

Results are

(1 rows affected)

(3 rows affected)

(2 rows affected)

What I would like to know is how can i input the file name after each file is executed and this name stored in the output.txt file ie

(1 rows affected)

Script1.sql

(3 rows affected)

Script2.sql

(2 rows affected)

Script3.sql

Any help appreciated

foxidrive · Accepted Answer · 2014-08-18 14:39:38Z

4

Just output the file name, what's problem?

for %%f in (*.sql) do (
   echo %%~nf >> output.txt
   sqlcmd.exe  -S %sname% -d %dbname% -i %%f  >>output.txt
)

edited Aug 18, 2014 at 14:39

foxidrive

41.4k11 gold badges61 silver badges71 bronze badges

answered Aug 18, 2014 at 13:53

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

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

3 Comments

Visual Basic .Net Over a year ago

This only prints the file name in the command line, I need to print it in the output.txt file

Visual Basic .Net Over a year ago

No, Im stuck on this one. Any help will be appreciated.

foxidrive Over a year ago

Try it now. It was missing a closing parenthesis.

Collectives™ on Stack Overflow

Command Line, File Name for each script executed. SQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related