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
Tag Archives: SQLCMD command
: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.
: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
:SETVAR [""] SQLCMD Command
: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
[:]EXIT[(statement)] SQLCMD Command
[:]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
[:]QUIT SQLCMD Command
[:]QUIT This command immediately ends the current SQLCMD session without running any statements in the statement cache.
[:]!! SQLCMD Command
[:]!! <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