Partager via


CommandShellWithResults Method

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The CommandShellWithResults method returns a QueryResults object enumerating execution output from an operating system command executed on an instance of Microsoft SQL Server.

Syntaxe

object
.CommandShellWithResults(
Command
)
as 
QueryResults

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

  • Command
    Operating system command string.

Prototype (C/C++)

HRESULT CommandShellWithResults(
SQLDMO_LPCSTR Command,
LPSQLDMOQUERYRESULTS* ppResults);

Returns

A QueryResults object that contains one result set defined by this value

Column name

Data type

Description

output

varchar(512)

First 512 characters of a line of text generated by operating system command execution

Notes

SQL Server implements secure access to the operating system through a number of security mechanisms. For more information about configuring access to the operating system, see xp_cmdshell.

Applies to: