Pages
Tags
:ERROR SQLCMD Command :LIST SQLCMD Command :LISTVAR SQLCMD Command :ON ERROR :ON ERROR SQLCMD :PERFTRACE SQLCMD :PERFTRACE SQLCMD Command :XML :XML SQLCMD Command :XML [ON/OFF] SQLCMD Command Automate Backup with SQLCMD CMD command CMD list of the servers OPENROWSET OPENROWSET excel file OSQL RESET SQLCMD command SERVERLIST SERVERLIST SQLCMD Command SQLCMD SQLCMD Backup SQLCMD Batch SQLCMD command SQLCMD list of the servers SQLCMD Script SQLCMD Scripting Variables SQLCMD Startup Script sqlcmd stored proc SQLCMD T-SQL SQLCMD Variables Startup Script stored procedure sqlcmd XP_CMDSHELL XP_CMDSHELL excel file XP_CMDSHELL SQL 2000 XP_CMDSHELL SQL 2005 XP_SMDSHELL [:]ED SQLCMD Command [:]EXIT[(statement)] SQLCMD Command [:]QUIT SQLCMD CommandCategories
Monthly Archives: August 2009
SQLCMD Startup Script
SQLCMD can run a startup script defined by the environment variable SQLCMDINI. Suppose you want to always execute the following query when you are connected to the server: SELECT @@SERVERNAME, @@VERSION Place this command inside the init.sql file and define … Continue reading
SQLCMD Scripting Variables
It’s a good idea to discuss scripting variables at this point before discussing different SQLCMD commands, primarily because certain commands reveal their true power only via leveraging scripting variables. SQLCMD variables are different from T-SQL variables in many aspects. The … Continue reading
:XML [ON/OFF] SQLCMD Command
:XML [ON/OFF] When you expect XML data to be coming back from the server, for example because of a FOR XML clause in your query, you should set XML mode to ON via this command, to properly format the output. … Continue reading
Posted in Uncategorized
Tagged :XML, :XML [ON/OFF] SQLCMD Command, :XML SQLCMD Command
Leave a comment
:ON ERROR [exit/ignore] SQLCMD Command
:ON ERROR [exit/ignore] This command instructs SQLCMD on how to handle errors during script execution. The following options are available: * exit Exits the program with the appropriate error value * ignore Ignores the error and continues execution. An error … Continue reading
:PERFTRACE /STDERR/STDOUT SQLCMD Command
ERFTRACE <filename>/STDERR/STDOUT The ERFTRACE command redirects all performance information (see the discussion of the -p option) that by default goes to standard output.
Posted in Uncategorized
Tagged :PERFTRACE SQLCMD, :PERFTRACE SQLCMD Command, SQLCMD command
Leave a comment
:OUT /STDERR/STDOUT SQLCMD Command
:OUT <filename>/STDERR/STDOUT This command redirects all query results output that by default gets sent to standard output.
:ERROR /STDERR/STDOUT SQLCMD Command
:ERROR <filename>/STDERR/STDOUT This command enables the user to redirect error output, either to a specified file or to standard error/standard output console streams. You may want to refer back to command line option -r, discussed earlier in this chapter. Tips … Continue reading
:SERVERLIST SQLCMD Command
:SERVERLIST This command corresponds to the command line option -L, listing all locally configured servers and the names of the servers broadcasting on the network. How does it help you to know the names of all servers when you are … Continue reading
Posted in Uncategorized
Tagged SERVERLIST, SERVERLIST SQLCMD Command, SQLCMD command
Leave a comment
:r SQLCMD Command
:r <filename> This option enables the script writer or interactive user to read the contents of a specified script file and include it in the current execution session. The included file is processed in-place; in other words, every command encountered … Continue reading