CMDSQL - A Command Line Programm for MS SQL Server

More Console Programs

Site Home

CMDSQL - A Command Line Programm for Accessing Microsoft SQL Server

Features

Supports: Windows NT Authentication login and SQL Server Account login;
Works in: Interactive mode or Silent mode;
Input: Can be command line sql or a sql script file
Output: The console window, text file, html file, excel file.

Screenshots

Command Line Parameters

cmdsql takes upto 7 command line parameters.

1	Server	The name or IP of the MS SQL server. If set to "?", cmdsql ignores other parameters, scans available SQL servers by UDP broadcasting, then exits.
2	user	The login name of the user's account. If set to blank, Windows NT Authentication (trusted connection) is used.
3	password	The login password of the user's account.Ignored if user is blank.
4	database	The name of the database to open.
5	sql	the SQL commands or SQL script file path to be executed.
6	Output	blank: Output to console window. print: Output to default printer. copy: Output to text clipboard. Text File Path: Output to text file. HTML File Path: Output to HTML file. Excel File Path: Output to Excel Sheets.
6	Output Control	-r: Suppress query results (recordsets) -m: Suppress message +open: Open output file

Usage Examples

Command Line	Action
cmdsql (local)	Login to the local SQL server using Windows NT Authentication. cmdsql enters Interactive Mode.
cmdsql mysvr "" "" msh	Login to SQL Server "mysvr" using Windows NT Authentication and open "msh" as current database. cmdsql enters Interactive Mode.
cmdsql mysvr john john-pass	Login to SQL Server "mysvr" using SQL Server Account. cmdsql enters Interactive Mode.
cmdsql mysvr john john-pass msh	Login to SQL Server "mysvr" using SQL Server Account and open "msh" as current database. cmdsql enters Interactive Mode.
cmdsql mysvr "" "" msh "select * from [Employees]"	Login to SQL Server "mysvr" using Windows NT Authentication, open "msh" as current database, execute the sql, send output to console window, then exit.
cmdsql mysvr "" "" msh "script.sql" "query.htm" "-m+open"	Login to SQL Server "mysvr" using Windows NT Authentication, open "msh" as current database, execute the sql script file, save output to a HTML file, open the HTML file, then exit.

Interactive Mode

If less then 5 command line parameters are presend, CMDSQL enters interactive mode. In interactive mode, your SQL command is buffered - you don't have to finish a long SQL command in one line. The buffered SQL command will not be executed until you enter a CMDSQL command. A CMDSQL command determines how the buffered SQL command is to be executed. It can be:

go: Execute the buffered SQL, and display the record sets it may produce.
copy: Execute the buffered SQL, and copy the record sets it may produce to clipboard.
print: Execute the buffered SQL, and print the record sets it may produce.
savehtml=PATH[;open]: Execute the buffered SQL, save the record sets it may produce to a HTML file, and optionally open the HTML file.
savexls=PATH[;open]: Execute the buffered SQL, write the record sets it may produce to a Excel sheet, and optionally open the Excel file.

When one of the CMDSQL command is executed, the buffered SQL command is cleared.

The following CMDSQL commands do not execute the buffered SQL:

clear: Clear the buffered SQL command.
?: Display the buffered SQL command.
pagesetup: Open the Printer Page Setup Dialogbox.

Buy

The license fee is USD 7.50.
Our online payment service is provided by PayPal. If you don't have a PayPal account, you can still pay with credit card there.
Please make the payment by clicking the button below:
Within 24 hours of the payment confirmed by our payment service provider, we will send you the licensed copy.
If you have problems with our online payment service, please send a message to support@xuebrothers.net.

Contact: support@xuebrothers