SQLCMD Usage in Batch file

Question

Hi All I am Writing a Batch Script Which has to read a set of SQL Files which exists in a Folder then Execute Them Using SQLCMD utiliy.

When I am Trying to execute it does not create any output file. I am not sure where I am wrong and I am not sure how to debug the script. Can someone help me out with script?

@echo off

FOR %F IN (C:\SQLCMD*.SQL) DO sqlcmd -S LENOVO-C00 -U yam -P yam!@ -i %F -o C:\SEL.txt -p -b

IF NOT [%ERRORLEVEL%] ==[0] goto get_Error

:Success echo Finished Succesffuly exit /B 0 goto end

:get_error echo step Failed exit /B 40

:end

if not [%errorlevel%] ==[0] should be if errorlevel 1. Avoid using the pseudo-variable unless you have to since it can break. — Joey
– Joey, Commented Aug 24, 2010 at 6:20
It should be noted that it isn't necessary to keep your sql scripts in separate files. You can put the entire SQL statements inside the batch file and make them very human readable by using line separators with the carrot character and delayed expansion enabled. — djangofan
– djangofan, Commented Jan 13, 2012 at 0:01

Michael Burr · Accepted Answer · 2010-08-24 01:24:12Z

1

If this is actually in a batch file (not being executed by hand at the command line), then the %F variables need to have the % characters doubled-up because of the way that cmd.exe executes the lines read from the batch file:

FOR %%F IN (C:\SQLCMD*.SQL) DO sqlcmd -S LENOVO-C00 -U yam -P yam!@ -i %%F -o C:\SEL.txt -p -b

Though I would have thought you'd get a

F was unexpected at this time.

error if you only had one % character in front of the variable name.

answered Aug 24, 2010 at 1:24

Michael Burr

342k52 gold badges553 silver badges774 bronze badges

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

2 Comments

Anoop Over a year ago

Hi Michael Thanks for the Reply.After Adding the %% I was able to Run the batch file. But the script was not able to loop or iterate the file's.

Michael Burr Over a year ago

Anoop - comment out the "@echo off" so you can see exactly what commands the for command is trying to execute. That may give you a clue to what's going wrong. Alternatively, change the "DO sqlcmd ..." to "DO echo sqlcmd ..." to maybe help debug what's going on.

ramazan polat · Accepted Answer · 2010-08-24 01:22:57Z

1

Try to right click the Batch File and run as administrator.

answered Aug 24, 2010 at 1:22

ramazan polat

8,0484 gold badges57 silver badges86 bronze badges

Comments

djangofan · Accepted Answer · 2012-02-08 17:20:35Z

0

Seems like the answer would be more like this:

FOR %%F "usebackq" IN (`dir.exe C:\SQLCMD*.SQL`) DO ...

answered Feb 8, 2012 at 17:20

djangofan

29.9k62 gold badges211 silver badges308 bronze badges

Collectives™ on Stack Overflow

SQLCMD Usage in Batch file

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related