CommandShellWithResults Method
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。
The CommandShellWithResults method returns a QueryResults object enumerating execution output from an operating system command executed on an instance of Microsoft SQL Server.
構文
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 |
説明
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.