osql Utility(osql 工具)

osql 工具允许输入T_SQL语句，系统过程和文本文件，osql 用ODBC与服务器通信
The osql utility allows you to enter Transact-SQL statements, system procedures, and script files. This utility uses ODBC to communicate with the server.

语法：
osql
    [-?] |
    [-L] |
    [
        {
            {-U login_id [-P password]}
            | E        }
        [-S server_name[/instance_name]] [-H wksta_name] [-d db_name]
        [-l time_out] [-t time_out] [-h headers]
        [-s col_separator] [-w column_width] [-a packet_size]
        [-e] [-I] [-D data_source_name]
        [-c cmd_end] [-q "query"] [-Q "query"]
        [-n] [-m error_level] [-r {0 | 1}]
        [-i input_file] [-o output_file] [-p]
        [-b] [-u] [-R] [-O]
    ]

---

OSQL 命令
GO                             执行所有GO之前输入的语句
RESET                       清空所有输入的语句
ED                             调用编辑器
!! command                 执行操作系统命令
QUIT or EXIT( )        退出osql.
CTRL+C                     结束一个查询但不退出osql.

---

GO语句后面的整数代表命令的执行次数。例如
SELECT x = 1
GO 100
表示SELECT语句执行100次

osql每行不接受超过1000个字符，长句应该分成多行。