C:\Users\clu>sqlcmd -?
Microsoft (R) SQL Server Command Line ToolVersion 11.0.2100.60 NT x64Copyright (c) 2012 Microsoft. All rights reserved.usage: Sqlcmd [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection] [-N Encrypt Connection][-C Trust Server Certificate] [-d use database name] [-l login timeout] [-t query timeout] [-h headers] [-s colseparator] [-w screen width] [-a packetsize] [-e echo input] [-I Enable Quoted Identifiers] [-c cmdend] [-L[c] list servers[clean output]] [-q "cmdline query"] [-Q "cmdline query" and exit] [-m errorlevel] [-V severitylevel] [-W remove trailing spaces] [-u unicode output] [-r[0|1] msgs to stderr] [-i inputfile] [-o outputfile] [-z new password] [-f <codepage> | i:<codepage>[,o:<codepage>]] [-Z new password and exit] [-k[1|2] remove[replace] control characters] [-y variable length type display width] [-Y fixed length type display width] [-p[1] print statistics[colon format]] [-R use client regional setting] [-K application intent] [-M multisubnet failover] [-b On error batch abort] [-v var = "value"...] [-A dedicated admin connection] [-X[1] disable commands, startup script, environment variables [and exit]] [-x disable variable substitution] [-? show syntax summary]
Another approach would be to create a .BAT file with the following command:
for %%G in (*.sql) do sqlcmd /S servername /d databaseName -E -i"%%G" pause
Place this .BAT file in the directory from which you want the .SQL files to be executed, double click the .BAT file and you are done!
参数说明
-S [protocol:]server[instance_name][,port]
-d db_name
-E (use trusted connection)
-i input_file
-U login_id
-P password
错误1
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication..
错误2
加上用户名和密码后提示
Sqlcmd: The -E and the -U/-P options are mutually exclusive. 互斥的
修正
添加-U和-P，并且去掉-E就可以执行
输出到文件
脚本文件
(1).没有任何参数的for格式为：for %%i in (set) do command%%i 为变量set为一个文件或者一组文件，其实就是一个集合。可用通配符，比如*.txt。command 是要执行的命令。看个例子： 当前目录中有如下文件： a.txt b.mp3 c.mp3 c.wma a.rm e.bat你想显示里面的扩展名为mp3的文件，你会用什么命令呢？当然是dir了，dir *.mp3。 同样的，for也可以来实现，如下： for %%i in (*.mp3) do echo %%i 这如何理解？ for会先从括号里面执行，因为括号里面是*.mp3,所以for会先得到当前目录下所有的扩展名是mp3的文件，并把它们作为一个集合，而每个文件名就是一个元素， 像这样{b.mp3，c.mp3}，然后用%%i依次代替每个元素，之后做do后面的命令。当然，()里面不局限于一个文件或者通配符，可以有多个，比如：for %%i in (*.mp3,*.wma) do echo %%i 也是可以的。注意：do 后面可以跟任何命令，不要局限于echo，这里只是演示。 >清空文件，再写入
>>追加
脚本的注释::