ExecuteWithResults Method

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The ExecuteWithResults method executes a Transact-SQL command batch returning batch result sets in a QueryResults object.

Syntax

object
.ExecuteWithResults(
Command 
, [ Length ] )asQueryResults

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • Command
    String that specifies a Transact-SQL or provider-specific command batch.
  • Length
    Optional. Long integer that indicates the statement batch length.

Prototype (C/C++)

HRESULT ExecuteWithResults(
SQLDMO_LPCSTR Command,
LPSQLDMOQUERYRESULTS* ppResults,
long lLength);

Returns

A QueryResults object.

Hinweise

When using the ExecuteWithResults method with the LinkedServer object, command batch syntax is provider-specified. For more information, see the OLE DB provider documentation.

Applies To:

Database Object

RemoteServer Object

LinkedServer Object

SQLServer Object