Category Archives: Uncategorized

:OUT /STDERR/STDOUT SQLCMD Command

Posted on August 16, 2009 by admin

:OUT <filename>/STDERR/STDOUT This command redirects all query results output that by default gets sent to standard output.

Posted in Uncategorized | Tagged , | Leave a comment

:ERROR /STDERR/STDOUT SQLCMD Command

Posted on August 16, 2009 by admin

: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 →

Posted in Uncategorized | Tagged | Leave a comment

:LISTVAR and :LIST SQLCMD Command

Posted on August 16, 2009 by admin

:LISTVAR and :LIST The LISTVAR command was mentioned earlier during the introduction of scripting variables. It lists currently defined variables and, as such, is handy in troubleshooting SQLCMD. There is a different command, LIST, which enables you to list contents … Continue reading →

Posted in Uncategorized | Tagged , , , | Leave a comment

:SERVERLIST SQLCMD Command

Posted on August 16, 2009 by admin

: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 , , | Leave a comment

:r SQLCMD Command

Posted on August 16, 2009 by admin

: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 →

Posted in Uncategorized | Tagged , | Leave a comment

:SETVAR [""] SQLCMD Command

Posted on August 16, 2009 by admin

:SETVAR <variable name> ["<variable value>"] The SETVAR option, already mentioned earlier during the discussion on scripting variables, enables you to set their values programmatically inside the script. One interesting aspect of the SETVAR command is that it is possible to … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

[:]EXIT[(statement)] SQLCMD Command

Posted on August 16, 2009 by admin

[:]EXIT[(statement)] This function has three distinctly different formats. *      :EXIT supplied without parenthesis has the same affect as QUIT. *      :EXIT() first executes previously accumulated statements and only then exits the session. *      :EXIT(query) first executes previously accumulated statements, then … Continue reading →

Posted in Uncategorized | Tagged , | Leave a comment

[:]QUIT SQLCMD Command

Posted on August 16, 2009 by admin

[:]QUIT This command immediately ends the current SQLCMD session without running any statements in the statement cache.

Posted in Uncategorized | Tagged , | Leave a comment

[:]!! SQLCMD Command

Posted on August 16, 2009 by admin

[:]!! <command> Typing !! allows the user to pass essentially any operating system command straight to the command line interpreter for direct execution and passes the output back to your display. Warning This is a very powerful option that can … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

[:]ED SQLCMD Command

Posted on August 16, 2009 by admin

[:]ED This command enables the user to call an editor on the current query buffer. The editor of choice is defined by the SQLCMDEDITOR environment variable. The default editor is “edit,” provided by the operating system. After the editor exits, … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment