回归命令行 sqlserver的命令行工具 sqlcmd（The command line tool sqlcmd return command line sqlserver）.docVIP

回归命令行 sqlserver的命令行工具 sqlcmd（The command line tool sqlcmd return command line sqlserver） The command line tool return command line SQLServer (1) - sqlcmd.exe (Part 1) This is for those of my colleagues before, often recall its spent on TARA ORACLE visit the day will feel now SQLServer those garish graphics interface is simply a profane database analyst, and deep sense of negative crime. I like TOAD, a powerful monster! Next were going to talk about sqlcmd.exe. sqlcmd is a good stuff ah, it is my most love daddy OSQL SQLServer tools, the number of fast, powerful, cool! Sqlcmd has been improved quite a lot in OSQL faster, more powerful, but the use of methods did not change much. SQL Server Management Studio as the birds do not know how many times. Accompanied by the use of for many years, enjoy OLE DB direct, comfortable ah! As usual, we used to see /? Sqlcmd boot parameters: C:\Documents and / Settings\chenxie.IFLYTEKsqlcmd.exe? Microsoft (R) SQL Server command-line tool The NT version of 9.00.1399.06 INTEL X86 Copyright (c) Microsoft Corporation. All rights reserved. Usage: Sqlcmd [-U ID] [-P login password The [-S server host name [-E [-H]]] trusted connection The use of [-d database name] [-l login timeout value [-t query timeout value]] [-h title] [-s column delimiter]] [-w screen width [-a packet size [-e echo input] [-I allows the quoted identifier. The [-c command [-L[c] server list [End] clear output [-q [-Q command line query command line query and exit] [-m error level] [-V serious level [-W to remove trailing spaces. [-u Unicode output [-r[0|1] messages sent to the stderr. [-i input file] [-o output file [-z new password]] [-f code page | i: code page [, o: code page ]] [-Z new password and exit] [-k[1|2] delete [replace]] control character [-y variable length type display width] [-Y fixed length type display width] [-p[1] print statistics [colon format [-R client use regional settings] [-b error abort batch] [-v variable = value...] [-A special conn