|
Carries out an operating system command from a procedure.
xp_cmdshell(
command
[ , 'no_output' ] )
command Use this CHAR(8000) parameter to specify a system command.
'no_output' Use this optional CHAR(254) parameter to specify whether to display output. The default behavior is to display output. If this parameter is the string 'no_output', no output is displayed.
xp_cmdshell executes a system command and then returns control to the calling environment.
The second parameter affects only console applications on Windows operating systems. For Unix, no output is displayed regardless of the setting for the second parameter. For NetWare, any commands executed are visible on the server console, regardless of the setting for the second parameter.
For NetWare and Windows CE, any commands executed are visible on the server console, regardless of the setting for the second parameter. On Windows CE, the console shell \\windows\cmd.exe is needed to run the procedure.
DBA authority required
The following statement lists the files in the current directory in the file c:\temp.txt:
xp_cmdshell( 'dir > c:\\temp.txt' )
The following statement carries out the same operation, but does so without displaying a command window.
xp_cmdshell( 'dir > c:\\temp.txt', 'no_output' )