How can i give UserName,Password,Database and all those things?
>
Plz send me details how to do that...if possible with example...
To expand on Erland's response, you can pass parameters on the command line
and reference using %1 through %9. The examples below execute all the
".sql" scripts in the current folder using the server, database, user and
password passed as command-line arguments.
FOR %%f IN(*.sql) DO SQLCMD -S %1 -d %2 -U %3 -P %4 -I -i "%%f"
FOR %%f IN(*.sql) DO OSQL -S %1 -d %2 -U %3 -P %4 -i "%%f"
--
Hope this helps.
Dan Guzman
SQL Server MVP
<ra********@gmail.comwrote in message
news:11********************@v3g2000hsg.googlegroup s.com...
Hi,
How can we execute SQL Scripts using Batch file???
i think Batch file should contain Username,Password,Database and
Scripts...
Using that file scripts should run...
How can i give UserName,Password,Database and all those things?
Plz send me details how to do that...if possible with example...
Thanx in advance,
RR...