System extended stored procedures
984
Other system extended stored procedures
The other system extended stored procedures included are:
♦
xp_cmdshell Executes a system command.
♦
xp_msver Returns a string containing version information.
♦
xp_sprintf Builds a string from a format string and a set of input
strings.
♦
xp_scanf Extracts substrings from an input string and a format string.
The following sections provide more detail on each of these procedures.
xp_cmdshell system procedure
Carries out an operating system command from a procedure.
[
variable
= CALL ] xp_cmdshell (
string
)
None.
xp_cmdshell executes a system command and then returns control to the
calling environment.
The following statement lists the files in the current directory in the file
c:\temp.txt
xp_cmdshell(’dir > c:\\temp.txt’)
xp_msver system function
Retrieves version and name information about the database server.
xp_msver (
string
)
The string must be one of the following, enclosed in string delimiters.
Function
Syntax
Permissions
Description
Example
Function
Syntax
To Next Page
Loading...