ExecuteImmediate Method (Database, SQLServer)

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The ExecuteImmediate method submits a Transact-SQL command batch on a connection, and directs execution or batch interpretation as specified by the application.

Syntax

object.ExecuteImmediate(Command , [ ExecutionType ] 
, [ Length ] )

Parts

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

• Command
  String that specifies a Transact-SQL command batch.

• ExecutionType
  Optional. Long integer that controls statement batch execution as described in Settings.

• Length
  Optional. Long integer that indicates the statement batch length.

Prototype (C/C++)

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

Settings

Set the ExecutionType argument using these values.

Constant	Value	Description
SQLDMOExec_ContinueOnError	2	Batch execution continues on any error that does not break the connection.
SQLDMOExec_Default	0	No statement execution options set.
SQLDMOExec_/NoCommandTerm	1	Ignore the command terminator in the script. Execute as a single batch.
SQLDMOExec_NoExec	4	Execute SET NOEXEC ON prior to batch execution. Execute SET NOEXEC OFF after batch execution.
SQLDMOExec_ParseOnly	8	Execute SET PARSEONLY ON prior to batch execution. Execute SET PARSEONLY OFF after batch execution.
SQLDMOExec_QI_ON	16	Execute SET QUOTED_IDENTIFIER ON prior to batch execution. Execute SET QUOTED_IDENTIFIER OFF after batch execution.

Applies To:

Database Object

SQLServer Object