SQLCMD and load any SQL files as *.sql (one sql file in one directory)

Question

Hi All,

please, 
How do I make SQLCMD retrieve any SQL file name using –i? (* .sql) If there will always be only 1 file *.sql in the directory?

Thx!
M2F

Answer 1

learn how to use FOR (i thought you did)

for %i in (*.sql) do sqlcmd -i % ...

(% has to be doubled %% inside .cmd script)

MP