ExecuteImmediate Method (LinkedServer, RemoteServer)

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 ExecuteImmediate method connects to a linked server or remote server data source, executes a Transact-SQL command batch on the connection, and disconnects.

Syntax

object
.ExecuteImmediate(
Command
, [ Length ] )

Parts

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

Prototype (C/C++)

HRESULT ExecuteImmediate(
SQLDMO_LPCSTR Command,
long lLength CPPDEFAULT(= 0));

Hinweise

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

Applies To:

LinkedServer Object

RemoteServer Object